how to remove duplicates in transformer stage by using
stage variables?one example?
- 6 Answers
- 31710 Views
- Syntel, TCS, I also Faced
- E-Mail Answers
Answer Posted / amit
using hash partition technique, we can bring duplicate data(based on key columns) in one partition. Then in stage constraints filter out data with setting @inrownum = 1.
This will remove duplicate in transformer stage.
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is the difference between the local container and shared container?
Define data aggregation?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are the differences between datastage and informatica?
root tree will find which is server job and which is parallel job?
Why do you need stage variables?
Why do we use link partitioner and link collector in datastage?
Name the third party tools that can be used in datastage?
Explain datastage architecture?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is quality stage?
