Answer / sam

Performance wise unconnected lookup transformation is better as it returns one port & does not build dynamic cache. only static cache is build .

What are the different threads in DTM process?

1 Answers  

---

How to do unit testing in informatica? How to load data in informatica ?

0 Answers  

---

When do you use mapping parameters? (In which transformations)

1 Answers  

---

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,

---

Which will beter perform IIf or decode?

3 Answers   TCS,

---

how can import the data from the flat files?

2 Answers  

---

what are the Methods For Creating Reusable Transformations?

0 Answers   Informatica,

---

following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'

2 Answers  

---

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 Answers  

---

can we use cartesian join in informatica

3 Answers   IBM,

---

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,

---

Different sorts of metadata that stores in the storage facility?

0 Answers  

---