how CAN we remove duplicates in dataset?
Answers were Sorted based on User's Feedback
Answer / disney
In dataset stage, Input tab of partitioning --> used the key
partition instead of auto partition , then check the
perform sort and check the unique, It will remove the
duplicate from dataset
| Is This Answer Correct ? | 25 Yes | 0 No |
Answer / markonda
by using remove duplicate stage we can remove duplicates
| Is This Answer Correct ? | 3 Yes | 6 No |
detail about sdlc
What are the important features of datastage?
how to sort two columns in single job in datastage.
What is apt_config in datastage?
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
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 the difference between orabulk and bcp stages?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What is the Difference Between DataStage 7.5 version and 8.1 Version?
In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..
Difference between in process and inter process?
i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?