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

What is a reference table in database?

0 Answers  


Which is the best graph database?

0 Answers  


What is the use of graph database?

0 Answers  


Under which circumstance should you create an index on a table?

0 Answers   3i Infotech,


can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?

0 Answers  






How does database replication work?

0 Answers  


Data structure used to implements a menu:

0 Answers   Verifone,


Explain phantom deadlock?

0 Answers  


Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?

0 Answers  


What is Object Oriented model?

0 Answers   Thomson Reuters,


List some advantages of dbms.

0 Answers  


You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

0 Answers   3i Infotech,


Categories