What is the fact table?

0 Answers  

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  

---

Does an informatica transformation support only aggregate expressions?

0 Answers  

---

there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,

---

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,

---

---

How to update a particular record in target with out running whole workflow?

0 Answers  

---

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,

---

what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,

---

Explian the connected and unconnected lookup transformation

1 Answers   Informatica,

---

what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,

---

What is the difference between IN and Exists in Oracle?

3 Answers   Deloitte,

---

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,

---