Answer / isha

Use ISNULL function to guide filter to handle null values.

NULL will return 0 and row will be dropped

Answer / sameer

Yes we write in filter conditions iif (isnull (cid),false,true) or using is_spaces function in there filter transformation and we can dropped the null records

Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  

---

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,

---

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  

---

Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

---

What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?

5 Answers   TCS,

---

What are the data movement modes in informatcia?

1 Answers  

---

Briefly explain the aggregator transformation?

0 Answers  

---

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  

---

Explain the code page compatibility?

0 Answers  

---

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

---

Describe an informatica powercenter?

0 Answers  

---

When do you use sql override in a lookup transformation?

0 Answers  

---