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 |
Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.
1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project
what is hash file
What are the types of hashed files in data stage
Where the datastage stored his repository?
what is difference between migration project and integration project? can anyone explain with the example Thanks in advance
how to do pergformence tuning in datastage?
Define Job control?
Explain entity, attribute and relationship in datastage?
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????
Explain connectivity between datastage with datasources?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10