Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 24650 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 do you import and export data into datastage?
what is repositery?
Differentiate between hash file and sequential file?
How a server job can be converted to a parallel job?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What steps should be taken to improve Datastage jobs?
What are the types of containers?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
how to export or import the jobs in .ISX file
Why do we use link partitioner and link collector in datastage?
Why do we use exception activity in Datastage?
What is size of a transaction and an array means in a datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are the types of hashed files in data 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
