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 many types of views are there in a datastage director?
How do you remove duplicate values in datastage?
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want
source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?
Why do we use link partitioner and link collector in datastage?
what is mapping lookup
if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
17 Answers IBM, TCS,
How can we improve performance of data stage jobs?
What is the method of removing duplicates, without the remove duplicate stage?
what is the main difference between sorragate key n primary key in one word
1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?
Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.