1)How to Duplicate Records Delete in Sequential file?
Answers were Sorted based on User's Feedback
Answer / naga
connect sequential file to dataset and use partition
technique and perform sort and select unique
Is This Answer Correct ? | 19 Yes | 6 No |
In the sequential File stage there is a option called filter.
there we can use UNIX command.
syntax for Remove duplicate: uniq or sort -u
Is This Answer Correct ? | 11 Yes | 1 No |
Why we need datasets ratherthan sequential files?
how to find no.of records in sequntial file itself?
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
what are the types of nodes
How to reverse the string using SQL?
Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?
What is the difference between operational data stage (ods) and data warehouse?
what is difference between migration project and integration project? can anyone explain with the example Thanks in advance
Define Routines and their types?
what is the use of surogate key in datastage
which r the connectors used in san?
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