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

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.

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.

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

---

why we use source qualifier transformation?

16 Answers   Accenture,

---

Without using Lookup & Sequence Generator, How to generate Sequence?

5 Answers   CTS,

---

How can we use batches?

0 Answers  

---

What is informatica? Why do we need it?

0 Answers  

---

---

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,

---

how do u get the first record from 50,000 records ?

10 Answers   TCS, UBS,

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

0 Answers   Cap Gemini, Cognizant,

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

0 Answers   HCL,

---

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,

---

What is a configuration management?

1 Answers  

---

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

---