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 can we create tables in datastage?
What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
what is the difference between the active datawarehouse and datawarehouse
what is the difference between 7.1,7.5.2,8.1 versions in datastage?
What is the project in datastage?
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
how can we join one oracle & flat files ?
I have a few records all are same structures data, I want to store data in multiple targets how?
which is the most complex job in your career? Please tell me answer?
Why do you need stage variables?
In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.
when we have to go for a sequential file stage & for a dataset in datastage?