in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,

---

Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 Answers  

---

If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?

5 Answers   TCS,

---

Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

1 Answers   Accenture, Patni,

---

permutations of mapplet

0 Answers   TCS,

---

---

State the differences between sql override and lookup override?

0 Answers  

---

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

---

Why do we need informatica?

0 Answers  

---

Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,

---

differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??

2 Answers   IBM,

---

in which situations do u go for snowflake schema ?

2 Answers   TCS,

---