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
- 3 Answers
- 8907 Views
- Deloitte, IBM, I also Faced
- E-Mail Answers
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
Could anyone give brief explanation bout datastage admin
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
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?
Define meta stage?
how to abort the job its matain duplicates?
How many Key we can define in remove duplicate stage?
What is the sortmerge collector?
What are system variables and sequencers in datastage
project Steps,hits, Project level HArd things,Solved methods?
What a datastage macro?
What are the functionalities of link partitioner and link collector?
Have you used Unstructured data?
What are stage variables?
What are the types of hashed files in data stage
Give an idea of system variables.
