Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the unique records on multiple columns by using
sequential file stage only
- 3 Answers
- 10116 Views
- I also Faced
- E-Mail Answers
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 are stage variables and constants?
Differentiate between datastage and datastage tx?
How many types of hash files are there?
Why fact table is in normal form?
What is datastage?
What is quality stage?
What is use Array size in datastage
Why we use surrogate key?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is the precedence of stage variables,derivations, and constraints?
What is orabulk stage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
what are the devoleper roles in real time? plz tell i am new to datastage....
Can you implement SCD2 using join, transformer and funnel stage?
