Answer / infa

using iif and isnull functions in expression

Answer / 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

Answer / murugan

normally router means multiple targets...first taget display
the null valuesw and another records display the non null
values..

what is fact and what types of fact tables is there

4 Answers   Cap Gemini,

---

How identifying bottlenecks in various components of informatica and resolving them?

0 Answers  

---

What are the scheduling options to run a sesion?

2 Answers  

---

1 lac of flat fles in source how to load target at a time?

4 Answers   Cap Gemini,

---

What are your source in project and how you import in informatica? How can i explain abt this?

1 Answers   Accenture, Unisoft Infotech,

---

WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers   TCS,

---

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,

---

suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

2 Answers   emc2,

---

What are the differences between joiner transformation and source qualifier transformation?

0 Answers   Informatica,

---

What is joiner cache?

2 Answers   TCS,

---

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers   Syntel,

---