how to get the unique records on multiple columns by using
sequential file stage only
- 3 Answers
- 8825 Views
- I also Faced
- E-Mail Answers
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
What is the flow of loading data into fact & dimensional tables?
What is the purpose of pivot stage and types of containers in datastage
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Explain connectivity between datastage with datasources?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Can you explain how could anyone drop the index before loading the data in target in datastage?
How do you schedule or monitoring the job?
What is difference between join, merge and lookup stage?
Triggers,VIEW,Procedures
What are the different types of lookups in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Can you implement SCD2 using join, transformer and funnel stage?
What is the difference between Datastage 7.5 and 7.0?
What are sequencers?
