Answer Posted / ramesh.b

hi,
normally router means multiple targets...take 2 groups first group condition isnull and second group condition not isnull.first group gives the null values and second group gives the non null values.

source-->sq-->expression-->router-->2 targets

What is joiner change?

1100

---

What is the fact table?

1013

---

On which transformations you created partitions in your project?

1281

---

Explain sql transformation in script mode examples in informatica

1074

---

Differentiate between source qualifier and filter transformation?

1529

---

During the running session, output files are created by informatica server. Enlist few of them.

949

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2002

---

What are ETL Tools?

1066

---

What is event and what are the tasks related to it?

1080

---

write a query to retrieve the latest records from the table sorted by version(scd)

1029

---

What are mapplets? How is it different from a Reusable Transformation?

1049

---

Difference between Target-based loading and constraint-based loading?

967

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10648

---

What are the informatica performance improvement tips

1045

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2085

---