100 records in source and i have 3 targets, my requirement is first record inse

100 records in source and i have 3 targets, my requirement
is first record insert into 1st target,2 record into 2nd
target,3 record into 3rd target and again 4th record into
1st target like dat..how to implement dis?

Question Posted / siva reddy

3 Answers
11533 Views
Polaris, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2..

Answer / manthiramoorthy. g

SQ-->EXP-SEQ-RTR-TARGETS

Router
=======
Make 3 Groups
MOD(NEXTVAL,3) = 0
MOD(NEXTVAL,3) = 1
MOD(NEXTVAL,3) = 2

Is This Answer Correct ?

13 Yes

2 No

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2..

Answer / mayur

SQ==>Sequence Generator(make it cycle of three)==> Filter
Tr==> Target

Is This Answer Correct ?

1 Yes

0 No

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2..

Answer / chandra

SQ--->EXP-->ROUTER---->TARs

In EXP take 2 output ports ,In one output port write
mod(id,3)=1and second Oport write mod(id,3)=2..,
Next drag the ports to ROUTER
In router take 2 groups ,IN first group write condition
mod(id,1)=1
and second group write condition mod(id,3)=2
finaly drag 3output groups into 3targets

Is This Answer Correct ?

3 Yes

3 No

Post New Answer

More Informatica Interview Questions

can session assigned multiple mappings or not?

2 Answers Zensar,

how to run the batch using pmcmd command

2 Answers Wipro,

What is the different lookup cache(s)?

0 Answers

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6 Answers IBM,

what is row level and column level indicator?

1 Answers TCS,

what is a transforamation?

5 Answers

what is the difference between informatica6.1 and infomatica7.1

0 Answers TCS,

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers Wipro,

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers

How/where can i install Informatica software with oracle or teradata as database

0 Answers

can you use flat file for repository?why?

2 Answers TCS,

Which is better performance wise database or file?How?

2 Answers TCS,

For more Informatica Interview Questions Click Here