File Name: datastage questions and answers .zip
Introduction to Datastage DataStage is an ETL tool that is used in graphical notation to build solutions to data integration. The job role in DataStage comprises the knowledge of data warehouse, ETL, data storage, configuration, design, various stages, and modules in data stages. DataStage is used to integrate various systems multiple systems and processes high volumes of data.
You can solve this problem by using two way 1. Transformer: Take two stage variables Svar1 and Svar2. Source have single column data, How can I get Target like row 1 goes to target 1, row 2 goes to target 2.
Target How can you achieve this scenario? We can use the option "generate multiple files" in sequential file stage and then assign the data column as Key.
SO with every change in key it will generate a new target file. There are thousand rows, who will write thousand different where conditions and then will configure different files, is there any other solution which dynamic? I have a source file having data like: 10 10 10 20 20 20 30 30 40 40 50 60 70 i want three output from the above input file, these output would be: 1 having only unique records no duplicates should be there. Like: 10 20 30 40 50 60 70 2 having only duplicate records, Hi, Can you please solve this in datastage..
Can you please elaborate the Staging variable condition? If the paralle or seq job do not have configuration file.. If the job throws any error if yes what type of error it will be.
How to find out second highest salary as group wise by using datastage? Can you explain scenarios like pre row salary, next row salary, rank and dense rank. Pre and next row salary can be get using analytical functions lag and lead functions in SQL. I have 10 Million records in source and target 5 million records were populated then job was aborted again i go and compile and run the job when that time job will run from 5million 1 record to remain records how? Use Upsert function in database connector stage.
Or use lookup stage to perform lookup on the source and reference as your target data and load into your target stage. Use below constraints in xfm to move the data into 3 different columns.
Make the xfm partition to run sequential. My input has a unique column-id with the values 10,20, If the input has 2 partion then i would get 2 rows for lastrow function. How to load the different data files in single target table using one data stage job? Files are having different name and data but target table in static.
If the input file has same metadata and matching file name pattern, then 1. Set Sequential file Read method property to "File Pattern" 2. Provide File Pattern Else, if different file name, then sp You can write a multi instance job. And parameterise the file name..
I have a sequential file it is having some records and the same file is having header and footer now my question is how to count the records in a file which is not counts the header and footer records and then transform the records in to target and then again we fetch the header and footer to that file which records are matched with the header.
How to get top five rows in DataStage? Thanks in advance!! If you want to use transformer only so you need to sort that data first Because inrownum and outrown Input file contains fields, target is 1st field is load into Target 1 2nd field is load into Target 2 3rd field is load into Target3 th field is load into Target How can achieve this scenario?
Create target with that one field in DML. Then use a reformat having input file and map each field to target as per requirement. I am using Datastage Any idea how to get this done? The variables which used in through out the system not in singale project is called System variables.
I have to design a job, if I run the job it should get 10 records from emp, if another person runs he should get all the records form emp. How to design such a job? If you are using Sequential file stage, there we have an option "Read the first row", make it parametrized. In a Column abcxyz convert into two files like fil1 and abcxyz file2. Hash partitioning and in link sorting on grouping keys give better performance and correct results if it is in parallel mode and Auto partition will give correct results if there is no sorting happened only one of the keys we are grouping in previous stage.
Hello Harish I would like to ask you a question How I can choose the appropriate partition for each stage and job how can I analyse situation thank you.
Scenario: Objective: The interface aims to consolidate the round-trip ticket cost of passengers. Description: The source file is a. There are many repetitions in the source file Reverse Duplication: eg. Remove the reverse duplicates and maintain the target in I tired your way but didn't get the expected output. I think you will get the result. I have column X which having 3 values A;B;C. How can I load these values into 3 diff cols in the target. If tomorrow I will receive values for same single column I will load into target cols respectively Same de-limiter?
Loop through the incoming field using looping functionality in transformer. Extract the individual values using field function and the iteration number. Output the individual values to the output link Please Turn OFF your ad blocker. Learn More. First Prev Next Last Page. Oct 20 PM. Gabbar Dec 8th, You can solve this problem by using two way 1. Mar 05 PM.
Yash Ojha May 9th, We can use the option "generate multiple files" in sequential file stage and then assign the data column as Key. Rv Dec 7th, There are thousand rows, who will write thousand different where conditions and then will configure different files, is there any other solution which dynamic? Oct 02 AM. Having single input source want three different outputs.
Mar 17 AM. How to convert multiple rows into single row in datastage sai DataStage Interview Questions. Alisha Aug 8th, Can you please elaborate the Staging variable condition? Jul 22 AM. If the job throws any error if yes what type of error it will be alex Oct 25th, Job will run using the default config file.
It will not bort. Feb 07 AM. Can you explain scenarios like pre row salary, next row salary, rank and dense rank Ranga Sep 6th, Pre and next row salary can be get using analytical functions lag and lead functions in SQL. Jul 28 AM. Nov 13 PM. Hari Mar 9th, Use Upsert function in database connector stage. Sep 03 AM. Hemant Mar 4th, Use below constraints in xfm to move the data into 3 different columns.
Feb 13 PM. Prashant Nov 25th, If your output file is sequential file then you can you use filter property. Prashant Nov 25th, If the input has 2 partion then i would get 2 rows for lastrow function.
May 16 AM. Hemant Nov 17th, If the input file has same metadata and matching file name pattern, then 1. Lokeswar Perugu Jun 18th, You can write a multi instance job. Jan 31 AM.
How to count the records except header and footer in a sequential file Venkat DataStage Interview Questions. Jan 03 AM. Mar 01 AM. Sandeep DataStage Interview Questions. Aug 04 PM. What about System variables? DataStage Interview Questions. Aug 15 PM. Shaktimaan May 2nd, If you are using Sequential file stage, there we have an option "Read the first row", make it parametrized. Feb 06 PM.
In DataStage interview questions, you will get all the information you need to clear your DataStage interviews with care. As part of these interview questions and answers, you will learn the difference between DataStage and Informatica, DataStage routine, join, merge, and lookup stages comparison, quality state, job control, performance tuning of jobs, repository table, data type conversions, and more. DataStage is a commonly used ETL tool in the current market. In this DataStage Interview Questions blog, we have shared an extremely useful set of questions and answers intended for cracking DataStage interviews. Here, we have provided in-depth solutions to the DataStage interview questions that are beneficial for freshers and experienced professionals alike. Go through these DataStage interview questions to easily crack your job interview: Q1.
About Me. DataStage Scenario - Problem1. DataStage Scenario - Problem2. DataStage Scenario - Design2 - job1. DataStage Scenario - Design2 - job2. DataStage Scenario - Design2 - job3. DataStage Scenario - Problem3.
Learn DataStage interview questions and crack your next interview. This course will help you to achieve excellence in this domain. Below mentioned are the Top Frequently asked Datastage Interview Questions and Answers that will help you to prepare for the Datastage interview. Let's have a look at them.
DataStage is an ETL tool. One can check the availability of the job across cities including Bangalore, Pune, Chennai and Hyderabad. It is used to integrate multiple systems and processes high volumes of data. DataStage has user friendly graphical frontend to design jobs.
A data stage is basically a tool that is used to design, develop and execute various applications to fill multiple tables in data warehouse or data marts. It is a program for Windows servers that extracts data from databases and change them into data warehouses. In Datastage 7. Merge means to join two or more tables. The two tables are joined on the basis of Primary key columns in both the tables.
All these questions are frequently asked ones and better prepare all these before attending your Datastage interview. It uses a graphical notation to construct data integration solutions and is available in various versions such as the Server Edition, the Enterprise Edition, and the MVS Edition. Are you booked for a DataStage interview? You may consider reading these few questions and answers before attending. They may be of great help to you in the long run.
Она повернулась. Неужели АНБ прослушивает мои телефонные разговоры.