how to get the unique records on multiple columns by using
sequential file stage only
Answer Posted / 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.
Command:
Sort |Uniq
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Describe the main features of 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.
How can we improve performance of data stage jobs?
Can you implement SCD2 using join, transformer and funnel stage?
What is the different type of jobs in datastage?
Give an idea of system variables.
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are the types of hashed files in data stage
How a server job can be converted to a parallel job?
what is the use of materialized view?
Explain entity, attribute and relationship in datastage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
how to abort the job its matain duplicates?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?