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..

In ur current projectu have done any performance tuning of mappings?

1 Answers  

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

0 Answers   Cognizant, Flextronics,

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  

---

How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,

---

What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,

---

which one is better either active or passive transformation in informatica

1 Answers  

---

Explain lookup transformation source types in informatica

0 Answers   Informatica,

---

How to open an older version of an object in the workspace?

0 Answers  

---

Explain target update override in informatica

0 Answers   Informatica,

---

how will you get 21 to 30 record from 50 records?

6 Answers  

---

Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,

---

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,

---