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
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
How many Key we can define in remove duplicate stage?
What is a ds designer?
What is the roundrobin collector?
How to clean the datastage repository?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
How and where you used hash file?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
AGGREGATOR default datatype
What are the different common services in datastage?
Notification Activity
What is staging variable?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Describe the main features of datastage?
What is ibm datastage flow designer?