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

Why use shortcuts(Instead of making copies).

1 Answers  

How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.

1 Answers   IBM,

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,

what is mapping parameter?

2 Answers   Cap Gemini,

How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

1 Answers  




Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.

2 Answers  

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  

What is rank transformation in informatica

0 Answers   Informatica,

What is joiner cache?

2 Answers   TCS,

How many repositories can we create in Informatica??

9 Answers   IBM, Patni,

If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,

What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories