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
how to write server Routine coding?
How will you move hashed file from one location to another location?
Notification Activity
What are the different kinds of views available in a datastage director?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is the difference between informatica and datastage?
How the ipc stage work?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
root tree will find which is server job and which is parallel job?
What is the difference between validated and compiled in the datastage?
Can you explain players in datastage?
What is job control?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What is quality stage?
What are the primary usages of datastage tool?