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 |
Name the third party tools that can be used in datastage?
what is the exact difference between dataset and fileset in datastage?
What is the difference between informatica and datastage?
Thanks to all people who are posting their comments...
Can we use target hash file as a lookup ?
What is the purpose of pivot stage?
How can we run same job in 1 day 2 times
How to read the length of word in unix?
What is audit table?
Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari
What is difference between join, merge and lookup stage?
Please tell me What is difference between 8.0 and 8.1