1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / manojdubba

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

What are the different caches used in informatica?

3 Answers   UST,

Without using Lookup & Sequence Generator, How to generate Sequence?

5 Answers   CTS,

Explain sessions. Explain how batches are used to combine executions?

1 Answers  

update strategy transformation in informatica

1 Answers   Informatica,

How will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

1 Answers   Cognizant,

What is the Hierarchy of DWH?

1 Answers  

What is Data Caches size?

1 Answers   Informatica,

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   CompuSoft, EDS, TCS,

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

how can we run workflow with pmcmd?

3 Answers   Wipro,

What is batch and describe about types of batches?

2 Answers  

For more Informatica Interview Questions Click Here
Categories