The .odbc.ini file gives information about connecting to the database (wire protocol drivers) or the database client (non-wire protocol drivers). If your system uses a mix of drivers, your …
This is one of the most asked DataStage scenario based interview questions. I will solve this problem by taking some sample data. Input file: Sno,name,salary,rank 1,Naveen,10000,2 2,Joe,20000,2 3,David,30000,1 4,Richard,30000,2 …
This question can be answered easily in SQL in the following ways. Finding the nth highest salary in Oracle using rownum: Find nth highest salary in Oracle using RANK(): …
What is the difference between Join/Lookup/Merge stages? How these will react if duplicates records come in input links? In join stage, if one input have col1,col2,col3 and other have …
Did you implement any SCD type in your jobs? If yes, Please explain it with job design. How can we implement SCD Type-2 in DataStage, Explain it in different …
Input file: Sno,name,salary,rank 1,Naveen,10000,2 2,Joe,20000,2 3,David,30000,1 4,Richard,30000,2 5,Obs,30000,1 1,Naveen,10000,2 1,Naveen,10000,2 3,David,30000,1 Output file: 1,Naveen,10000,2 1,Naveen,10000,2 3,David,30000,1 The final job design would be: First sequential file stage used to read …
What is a Surrogate Key, why we used it? How can we generate Surrogate Key in DataStage jobs? Explain the options available in the stage. Which are the Partition …
Problem: Oracle Connector Stage commits data even when a IBM DataStage job aborts and record count is zero. Symptom: Oracle Connector Stage commits data even when a IBM Data …
