Create a job to load all unique products in one table and the duplicate rows in to another table.
The first table should contain the following output
A
D
The second target should contain the following output
B
B
B
C
C
Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table.
The first table should contain the following output
A
B
C
D
The second table should contain the following output
B
B
C
Answer Posted / sudheer
answer for Q2, use sort stage and use generate change key column option. use filter stage to send all change key columns having value=1 to move in to a file which generates A B C D, and filter records having value=0 to another file which generates B B C.
Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Define data aggregation?
What are the different types of lookups in datastage?
How to read the length of word in unix?
Is the value of staging variable stored temporarily or permanently?
What are sequencers?
I have a few records just I want to store data in to targets cycling way how?
How rejected rows are managed in datastage?
Have you used Unstructured data?
Whats difference betweeen operational data stage (ods) and data warehouse?
Difference between in process and inter process?
How many types of stage?
What is the difference between in process and inter process?
What can we do with datastage director?
What is the purpose of pivot stage?
What is the use of datastage designer?