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 / nams
It can be done by unix uniq -u file_Name and uniq -d file_Name
or it can be done from datastage sequential file stage filter option from property.....write command overthere like above.....
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How many types of sorting methods are available in datastage?
describe the Steps to confiure a Qlogic switch
Why do we use exception activity in Datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Difference between server jobs & parallel jobs?
What are the important features of datastage?
What is the project in datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What are the types of hashed files in data stage
Describe stream connector?
Why do you need stage variables?
Could anyone give brief explanation bout datastage admin
What are the functionalities of link partitioner and link collector?