What are system variables and sequencers in datastage
- 0 Answers
- 830 Views
- I also Faced
- E-Mail Answers
What are the types of containers and how to create them?
Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers
In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.
what is the main difference between sorragate key n primary key in one word
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What are the functionalities of link collector?
How to Convert the columns into rows?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
how to identifie,is it innerjoin,leftouter join in lookup?
Teradata 
