I have a input as:

Col
1
1
2
2
3

I want 3 output as:

Output1:

1
1

Output2:

2
2

Output3:

3

i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

Answers were Sorted based on User's Feedback



I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2..

Answer / ankit kansal

Hi, if you know the number of duplicates coming your from source then it's easy to move the duplicates to the defined target using router transformation easily,
But if you do not know the number of duplicates then first you must sort the data on the value of duplicate column and then using Transaction Component as available in informatica you can create n no of targets depending upon the values encountered.

http://deepinopensource.blogspot.in/

Is This Answer Correct ?    1 Yes 1 No

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2..

Answer / kiran kumar

hi
put the hash partition in active stage then
make three node configuration then u got the output

Is This Answer Correct ?    2 Yes 2 No

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2..

Answer / suneelbabu.etl

can u mention some more input records as well output

Is This Answer Correct ?    0 Yes 0 No

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2..

Answer / sher

something like below should work...

Job#1
Read in transformer to add a new column sequence the value of sequence will be initially 1 and increment when key changes…
so output(A) will look like…
1 1
1 1
2 2
2 2
3 3
4 4
B 5
under job sequence, use a job activity to read(A) use tail -1 and | cut to read 2nd column. we get 5..
Now, use start loop activity and end look activity stage in job sequence to create a loop from 1 to jobactivity.output incrementing by 1..
The look will now run 5 times.. inside the loop, call a job and pass the value i.e 1,2,3,4,5 each time it runs.
Inside the called job, read the input file(A) pass to transformer and then use constraint to write only records where 2nd column = variable passed and drop column 2..
Output of transformer.
1st loop output
1
1
2nd loop output
2
2
and so on...
when writing the file, use the passed variable in file name, so file name is distinct

Is This Answer Correct ?    0 Yes 0 No

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2..

Answer / narayan

just add the mod function like this =MOD(inputcol|3) and then load into different targets

Is This Answer Correct ?    0 Yes 0 No

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2..

Answer / sivakeshava

hi friends by seeing the source we need 3 targets....which id duplicates 1,1 is one target, and 2,2 is 2nd target and 3 is another target
Seqfile------------ >copy -------------- lookup(innerjoin) ------------- filter

Aggregator---------------- > filter
(count) where clause

copy to aggregate then filter to lookup then will give 3 targets

Is This Answer Correct ?    0 Yes 0 No

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2..

Answer / ankur

Thats a good question... but unfortunately I dont know the ans.. Datastage gurus- can anyone help this guy and myself to know this question's ans.. Appreciate your feedback please!!

Is This Answer Correct ?    0 Yes 1 No

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2..

Answer / vaibhav

hello Ankit,

I need the ans in datastage..how this could be implemented in datastage?

Is This Answer Correct ?    0 Yes 1 No

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2..

Answer / vaibhav

Actually it is like:
I want as many target links as much u have types of duplicates in my input file.. Pls help guys..

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Data Stage Interview Questions

source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?

2 Answers   Wipro,


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?

0 Answers   Wipro,


Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.

1 Answers   IBM,


What is data partitioning?

0 Answers  


Is possible to create skid in dim,fact tables?

0 Answers   NTT Data,


where the log files or tables can store in DS?

2 Answers   IBM,


how to implement scd2 in datastage 7.5 with lookup stage

0 Answers   TCS,


Difference between in process and inter process?

0 Answers  


what is the use of surogate key in datastage

3 Answers  


In Datastage, how you can fix the truncated data error?

0 Answers  


eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers   Wipro,


how to validate the jobs

2 Answers   IBM,


Categories