How to remove duplicates in transformer stage? in parallel
mode
Answer Posted / satya
run u r job in sequencial mode and sort the source data
then play with stage variable's in Transformer.
because in parallel mode data is partioned .
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Difference between server jobs & parallel jobs?
What is usage analysis in datastage?
Define data aggregation?
What are datastage sequences?
how to implement scd2 in datastage 7.5 with lookup stage
How do you schedule or monitoring the job?
How to find value from a column in a dataset?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Explain Quality stage?
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
what is repositery?
What are the partitioning techniques available in link partitioner?
What is the differentiate between data file and descriptor file?
What are the components of datastage?
Where do the datastage jobs get stored?