Source File: Target
EMPNO, SAL Empno, Format
101, 1000 101, 1000
101, 1100 101, 1000, 1100
101, 1000 101, 1000, 1100, 1000
101, 10000 101, 1000, 1100, 1000, 10000
102, 1100 102, 1100
102, 1300 102, 1100, 1300
102, 1200 102, 1100, 1300, 1200
102, 1500 102, 1100, 1300, 1200, 1500
How can i get that output using datastage(ETL) tool


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Databases AllOther Interview Questions

can anyone please tell what are the roles and responsibilities of a teradata developer in detail???

1 Answers  


Is redis in memory database?

0 Answers  


what is tkprof tool and how it is used???

0 Answers   Genpact,


What are the two categories of Client-Server application development?

1 Answers  


Datatypes are unlimited,true or false?

2 Answers   Infosys,






What is the differnce between Order by and Group by

1 Answers  


What is the Lock Based Protocol used for?

0 Answers   Hexaware,


What is the database url?

0 Answers  


sparse lookup and where its options we find in OCI and db2?

0 Answers   TCS,


What is global database name?

0 Answers  


When should you not use firebase?

0 Answers  


A design problem was given in which I was supposed to make a design for the data base for a given problem.

0 Answers   Motorola,


Categories