Answer / rkumar.etl

Unit testing in Informatica performed using ...

1)src qualifier query if providing us the final result
..with only calculating logic in between than ...test the
count results in sql navigator.

2)column to column mapping to make sure the result passing
to columns are correct.

3)data type mismatch or matched.

In joiner, how to load Master table in Target?

2 Answers  

---

can any one explain me about junk dimension

4 Answers  

---

how can u approach u r client

2 Answers   CTS,

---

how to get the first row without using rank t/r?

7 Answers   iGate,

---

what are the row and column separations in Flat Files

3 Answers   CTS,

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1 Answers  

---

what is mapping parameter?

2 Answers   Cap Gemini,

---

How to display null values on a target & non-null values on a target?

3 Answers  

---

What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

15 Answers   Deloitte,

---

Mapplets can you use an active transformation in a mapplet,

1 Answers  

---

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,

---

How are parameters defined in informatica?

3 Answers   HP, TCS,

---