Answer Posted / krish

i really did'nt understand one thing if the target has PK on
it any of the methods specified above will not work.

let us think there is no PK on our T/G

the also all the methods above is wast of time

just run the secession 4 times

but the main thing (don't enable truncate the target table
option) .,.
if he say other than this option

then
Sai.masarapu.chowdary ans is good we can go with that.

Under what condition selecting sorted input in aggregator may fail the session?

1057

---

How to call shell scripts from informatica?

935

---

What are the types of schemas we have in data warehouse and what are the difference between them?

888

---

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3812

---

What are the differences between oltp and olap?

921

---

What are Dimensional table?

999

---

Is it possible to define a single node as a Gateway node as well as worker node?

1058

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1628

---

Enlist the tasks for which source qualifier transformation is used.

981

---

What is the use of an aggregator cache file?

1140

---

Can you generate sequence numbers without using the sequence generator transformation?

1050

---

Tell me about Propagate functions in informatica

874

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1842

---

Differentiate between router and filter transformation?

952

---

Which development components of informatica have the highest usage?

984

---