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...


Hi,
In Router transformation I created two groups .
One is Passthrough=> True
Second one is CorrectId’s => Invest>50000
Here I have one doubt. Can’t I treat default group as
Passthrough group (fist group) . Is there any difference
between default group and Passthrough group in this
scenario?
Let me know if you want more information about this
scenario.
Advance thanks.

Answers were Sorted based on User's Feedback



Hi, In Router transformation I created two groups . One is Passthrough=>..

Answer / srinivas

yes there is a diff in this scenario.
the first group (pass through) will pass all the records with all invests
second group will pass invests > 50000 and
finally if u want to use the default group instead of first group then,
default group will pass all the records with
invest <= 50000

correct me if i am wrong

Is This Answer Correct ?    6 Yes 0 No

Hi, In Router transformation I created two groups . One is Passthrough=>..

Answer / priyank

Hi,

In Router, we can create multiple groups based on the
different filter conditions.Default group as the name
suggests gets created by Default.When source data pass
through the router, it sends records to the different
targets based on the filter condition and if still there
are some rows which does not satisfy any of the group
conditions, then those records go through the Default group.

So in your case, there would be no records, which go
through the default group as all the records pass through
the "Passthrough" group.

Is This Answer Correct ?    4 Yes 0 No

Hi, In Router transformation I created two groups . One is Passthrough=>..

Answer / c manojkumar

Thanks Srinivas and priyank for your inputs.

Yes I got it now. I can't use default group insted of
passthrough. since passthrough group will have all the
records where as defalult group will have only few i.e. the
records which did not meet any of the group conditions.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

permutations of mapplet

0 Answers   TCS,


What is a configuration management?

1 Answers  


Explain factlessfact table with scenario

1 Answers   HCL,


whats the option in informatica 7 version is outdated in informatica 8 version onwards.

1 Answers   iGate,


How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,


What is deployment group?

0 Answers  


How do you create single lookup transformation using multiple tables?

6 Answers   TCS,


source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

1 Answers   IBM,


how to connect two or more table with single source qualifier?

4 Answers   IBM,


What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

1 Answers   Altisource, Patni,


what is diffrence b/w joner and union transfermation

6 Answers  


sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  


Categories