I have in my source Records like 100,101,102 etc. I have
router transformation which has groups like one group is
empno=100, second group is empno>99. Now i want to know my
source record 100 loads into which group?

Answers were Sorted based on User's Feedback



I have in my source Records like 100,101,102 etc. I have router transformation which has groups lik..

Answer / santosh

The record will be loaded into both the groups.

Is This Answer Correct ?    32 Yes 0 No

I have in my source Records like 100,101,102 etc. I have router transformation which has groups lik..

Answer / srinivas

100 will load into both the groups

Is This Answer Correct ?    15 Yes 0 No

I have in my source Records like 100,101,102 etc. I have router transformation which has groups lik..

Answer / gandra

the source record 100 will go to the two groups that
empno=100 and empno>99.

Is This Answer Correct ?    9 Yes 0 No

I have in my source Records like 100,101,102 etc. I have router transformation which has groups lik..

Answer / rampriya

if your input satisfies the condition of all your input
groups, then it will go into all of your groups excluding
default group. thats the only reason why router
transformation is active transformation

Is This Answer Correct ?    3 Yes 1 No

I have in my source Records like 100,101,102 etc. I have router transformation which has groups lik..

Answer / abhishek kumar

my source record 100 loads into one group. because router
first check first group than after second conscecuently.

Is This Answer Correct ?    3 Yes 11 No

Post New Answer

More Informatica Interview Questions

Clarify the utilization of aggregator cache record?

0 Answers  


Explain Dataware house architecture .how data flow from intial to end?

0 Answers   Keane India Ltd,


How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,


What does reusable transformation mean?

0 Answers  


How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?

1 Answers   Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,






Kimball and Inmon methodologies?

2 Answers  


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

0 Answers   IBM,


Can you generate reports in Informatcia?

1 Answers  


Tell me about informatica architecture.

2 Answers   TCS,


what is a transforamation?

5 Answers  


source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,


which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,


Categories