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

I have a condition sal=100 and I created one router and in
that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100,
first which condition will satisfy, and Why?

Question Posted / guest

Answers were Sorted based on User's Feedback



I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<..

Answer / rajasekar c

Sal=100 will satisfy both groups bcz in Infrmatica,all the
records are checked for all the group conditions,where ever
it satisfy the condition it goes to that group.(It is not
like if ... else).

Is This Answer Correct ?    13 Yes 0 No

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<..

Answer / rajasekar c

No Murali.. Here, if the sal=100 then it will goes to both
g1 and g2.That is why I mentioned "It is not like
If..else".

Is This Answer Correct ?    12 Yes 0 No

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<..

Answer / rajasekar c

Jegan ... It will go to both groups ... That is why I
mentioned that it is not like If ... else ...

If you still have doubt then just check with some test
files ...

Is This Answer Correct ?    7 Yes 0 No

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<..

Answer / rashmi garg

this row (sal =100) will satisfy both the conditions and
will be routed to the transformation or target of both the
groups

Is This Answer Correct ?    5 Yes 0 No

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<..

Answer / pramod

Yes, raj is right, its not like if one condition satisfies
it wont go to next condition, in informatica it will check
with all the groups whatever it satisfies then record will
pass, can try this.

Is This Answer Correct ?    4 Yes 0 No

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<..

Answer / prasanna

in router t/r if row meets more than one condition
informatica server passes that row multiple times

Is This Answer Correct ?    3 Yes 0 No

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<..

Answer / nadeem khan

As we know that Router is an active transformation and here is the example to suits that properties. In Router, condition will check for each group simultaneously. and where ever it satisfies, record will route from those groups.

Is This Answer Correct ?    0 Yes 0 No

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<..

Answer / nishanth

yes, in router it will satisfy and transferred to both groups , but is this the same scenario with lookup also?

can any one tell ?

Is This Answer Correct ?    0 Yes 0 No

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<..

Answer / ram patil

Only display record both conditions are not executed

SQ->FILTR->RTR>TRG1>TRG2

Is This Answer Correct ?    0 Yes 0 No

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<..

Answer / murali

it will work on SAL<=100 firstly, as if we have put this
condition in the G1 group. and for the remaining, there is
no need to give any condition. remaining all will fall
under SAL>=100 only. these records, u can get them into the
target from the default group...

Is This Answer Correct ?    0 Yes 8 No

Post New Answer

More Informatica Interview Questions

What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

2 Answers   IBM, Wipro,

Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,

The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers   Cap Gemini,

If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,




How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  

how do u move the code from development to production?

6 Answers  

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  

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

1 Answers   IBM,

How can we eliminate duplicate rows from flatfile,explain?

3 Answers  

For more Informatica Interview Questions Click Here
Categories