Answer / ahalya inturi

target load plan defines order in which data extracted from
source qualifier transformation

Answer / srinivas

suppose i have 3 pipelines in a single mapping designer

emp source--->sq--->tar1
dept source--->sq--->tar2
bonus source--->sq--->tar3

my requirement is to load first in tar2 then tar1 and then finally tar3

for this type of loading to control the extraction of data from source by source qualifier we use target load plan

How to join three sources using joiner?

0 Answers  

---

What is the functionality of update strategy?

2 Answers  

---

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

---

Define joiner transformation?

0 Answers  

---

i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers  

---

What are slowly changing dimensions?

5 Answers   Informatica, Verinon Technology Solutions,

---

Quickly characterize reusable change?

0 Answers  

---

Explain target update override in informatica

0 Answers   Informatica,

---

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,

---

What is limitations of truncate and load option

1 Answers   Cap Gemini,

---

What is the difference between view and materialised view?

4 Answers  

---