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

How will you check the bottle necks in informatica? From where do you start checking?

3 Answers   HCL,

---

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,

---

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

0 Answers   TCS,

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

0 Answers   HCL,

---

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

6 Answers   TCS,

---

---

What is a filter transformation?

0 Answers  

---

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

---

Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,

---

What is the scenario which compels informatica server to reject files?

0 Answers  

---

How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,

---

what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

---

how to design mapping half of source table records into one target and remaining half into another target

8 Answers   ABC,

---