how to get the unique records on multiple columns by using
sequential file stage only
Answer Posted / subhash
SORT -u file_name.txt
or
SORT|UNIQ file_name.txt
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the flow of loading data into fact & dimensional tables?
Is possible to create skid in dim,fact tables?
State the difference between an operational datastage and a data warehouse?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Define meta stage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is job control?
How to implement complex jobs in data stage?
Name the different sorting methods in datastage.
What are the steps needed to create a simple basic datastage job?
sed,awk,head
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What is the use of datastage designer?
What is the difference between server job and parallel jobs?