loading data in different targets

[harivasireddy]

Hi Everyone,

I have one source file with 100 records and I have 3 targets(datasets).
My requirement is loading the source data as
1st record should go to first target Dataset,
2nd record should go to 2nd target Dataset,
3rd record should go to 3rd target Dataset and then

4th record should go to 1st target,
5th record should go to 2nd target,andn
6th record should go to 3rd target and then

7th record should go to 1st target and so on....(until last record)

Can any one tell me the way, how I can do this without using any partitionsing techniques..

Thanks in Advance.

[manoj_23sakthi]

Hi,
This can be obtain
<File100records> + <Column Generator>
(Create a new column with datatype char and give Input as 1st value A,2st value B,3st value C,)

<Use transformer or filter or switch > and split A,B,C
you can obtain 3 Datasets us you Required
Regards,
Manoj

[harivasireddy]

Thanks for your response.

But, Iam not clear by the above.
If I have five targets, what I need to do.Can you please tell me in a detailed manner.

[radhakantkumar@gmail.com]

hi
i am completely Agree with above answer here i am giving new solution for loading into different target in cyclic order of 3..
take transformer after source data and generate a sequence order and store into a variable say Sv
and write three constraint .
1)Sv=1 or mod(sv,3)=1
2) Sv=2 or mod(sv,3)=2
3) Sv=3 or mod(sv,3)=3
This is example for three different target u can add for more....

thanks&regards,
Radhakant

[ray.wurlod]

Mod(sv,3) can never be 3.

[radhakantkumar@gmail.com]

Mod(sv,3) can never be 3. ...

Oh you are right ray.. please make it 0 in place of 3 that mean
Mod(sv,3)=0