how to get the unique records on multiple columns by using
sequential file stage only
Answers were Sorted based on User's Feedback
Answer / chandu
in sequential file there is one option is there i.e
filter.in this filter we use unix commands like what ever we
want.in this question we use uniq command in filter.
|Is This Answer Correct ?||7 Yes||0 No|
Answer / todearhari
Just a small correction to Above Answer ,First we need to sort the Data then use the Uniq then only you will get Complete uniq records as uniq compares line by line.
|Is This Answer Correct ?||2 Yes||0 No|
Explain entity, attribute and relationship in datastage?
What is difference between server jobs & parallel jobs?
I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A
how will u design file watch jobs?
what is repositery?
What is the method of removing duplicates, without the remove duplicate stage?
How will you move hashed file from one location to another location?
How to initialize environment variables?
Does datastage support slowly changing dimensions ?
CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?
i have the source from Uk,north america how can i pass the data two tables based on the locations
how can we create rank using datastage?what is the meaning of rank?