Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,

What is a filter transformation and why it is an active one?

0 Answers  

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 Answers  

what are the deliverables?in your project?

0 Answers   DELL,

How to get EVEN & ODD numbers separately?

8 Answers  

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

What is dynamic cache?

0 Answers  

Explain grouped cross tab?

1 Answers   Accenture,

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers   IBM, Infotech,

Mention few advantages of router transformation over filter transformation.

0 Answers  

what is SDLC way of code development?

0 Answers  

For more Informatica Interview Questions Click Here
Categories