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 |
how do u reduce warnings
i have the source from Uk,north america how can i pass the data two tables based on the locations
What is a merge?
How can you join flat file, oracle as a sources?
Pls tell me what is troubleshooting in datastage view?
In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?
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?????
how to remove duplicates in transformer stage by using stage variables?one example?
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?
what is a nodemap constraint
how can you generate sequence number using only the sequential file stage?
What is datastage engine?