Answer / swetha

A Router transformation is similar to a Filter
transformation because both transformations allow you to
use a condition to test data. However, a Filter
transformation tests data for one condition and drops the
rows of data that do not meet the condition. A Router
transformation tests data for one or more conditions and
gives you the option to route rows of data that do not meet
any of the conditions to a default output group. If you need
to test the same input data based on multiple conditions,
use a Router Transformation in a mapping instead of creating
multiple Filter transformations to perform the same task.

Answer / manjunath

Router transformation is a active and connected transformation,
It is used to test multiple conditions in which it has two groups 1.Input group 2. output group . In router transformation
rejected rows will be sent to default group where we dont have in filter t/f. Router t/f is connected to multiple targets.

Let me know if iam wrong

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers   CTS,

---

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

---

,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

3 Answers   Emphasis,

---

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,

---

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers   TCS,

---

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

---

what is mapping override?

2 Answers   Cap Gemini,

---

what is the drillup & drill down?and use of the drill up and drill down?

1 Answers   IBM,

---

when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,

---

How can we use mapping variables in informatica? Where do we use them?

0 Answers  

---

What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers   IBM, Wipro,

---

Differentiate between a database and data warehouse?

0 Answers  

---