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 |
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Could anyone give brief explanation bout datastage admin
what is the use of surogate key in datastage
What is process model?
I have a few records just I want to store data in to targets cycling way how?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
what is the exact difference between dataset and fileset in datastage?
Does datastage support slowly changing dimensions ?
Have you have ever worked in unix environment and why it is useful in datastage?
I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A
table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?
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.