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.

What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,

---

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  

---

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

---

can every transfomation reusable?how?

2 Answers   Wipro,

---

how to load only the first and last record of a flat file into the target?

8 Answers   CTS,

---

---

Why the workflow is failed after running two hours in informatica?

1 Answers   GE,

---

What is enterprise data warehousing?

0 Answers  

---

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers   IBM, Polaris,

---

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

5 Answers   DELL,

---

if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,

---

What are mapplets?

0 Answers  

---

How to elaborate powercenter integration service?

0 Answers  

---