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/

Answer / kiran kumar

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

Answer / suneelbabu.etl

can u mention some more input records as well output

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

Answer / narayan

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

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

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!!

Answer / vaibhav

hello Ankit,

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

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..

source contains 2 columns comes to target 4 columns how

1 Answers   IBM,

Can you explain engine tier in information server?

0 Answers  

what is executable in DataStage?

2 Answers  

what is the custome stage in datastage? how can we impliment that one? plz tell me

0 Answers   Accenture,

I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time

7 Answers   TCS,

What are the partitioning techniques available in link partitioner?

0 Answers  

How to lode data in sequntional files perform faster?

1 Answers   Polaris,

what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,

i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

11 Answers   Cap Gemini,

1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?

6 Answers   CTS, HCL, IBM, Wipro,

hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz

4 Answers  

Can aggregator and transformer stages use to sort the data? How ?

2 Answers