I have source file which contains duplicate data,my
requirement is unique data should pass to one file and
duplicate data should pass another file how?
- 7 Answers
- 21585 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / farzana kalluri
input output
1 T1 T2
2 4 1
2 6 2
1 7 3
3 4
4 5
3
5
5
6
7
for this
seq file---->Aggregate(key=id)---->filter---->2 targets
In aggregate use count rows...
in filter count=1 it goes to target1
if count=2 it goes to target2..
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
how to delete one row in target dataset
What is the difference between passive stage and active stage?
What are the partitioning techniques available in link partitioner?
What is datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What are stage variables?
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
Define APT_CONFIG in Datastage?
Where do you see different stages in the designer?
How do you import and export the datastage jobs?
What are stage variables, derivations and constants?
How one source columns or rows to be loaded in to two different tables?
In Datastage, how you can fix the truncated data error?
