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

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,


how to load rows into fact table in data warehouse

0 Answers   Informatica,


How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers  


WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.

2 Answers  


Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,






what are the output files that the informatica server creats during running a session?

2 Answers   CTS,


I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?

1 Answers  


What is the difference Between Mapping parameter and variable

3 Answers   Accenture,


How to extract the informatica rejected data?

0 Answers  


what are the differences between powercenter 8.1 and powercenter 8.5?

2 Answers  


What are the Differences between static cache and dynamic cache?

1 Answers  


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  


Categories