i want send my all duplicate record one tar and all uniq
records one target how we will perfome explain
example:
input data
eid
251
251
456
456
951
985
out put/target1
251
251
456
456
out put/target2
951
985
how we will bring
Answer Posted / vsandu
just sort the data ,and bring key changevalues by using
sort ,
in transformer write a logic if group id is 1,0 then target
1 else if group id is anly 1 then target2
as per my knowledge ,if any mistake correct me
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
What are stage variables?
What is the difference between the local container and shared container?
What is a merge?
Can you explain engine tier in information server?
Explain connectivity between datastage with datasources?
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.
how to abort the job its matain duplicates?
How to manage date conversion in Datastage?
What are the primary usages of datastage tool?
How do you remove duplicate values in datastage?
What is the difference between Datastage 7.5 and 7.0?
what is ds administrator used for?
What is ds designer?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How many types of views are there in a datastage director?