Answer Posted / usha

without using update transformation we can update by using
update overide if the target doent have a PK...

:TU

------------------------
push down operation in informatica means it will convert
transfromation logic to SQL query..
3 types..

source push down
target push down
full push down.

------------------------
connected lkp will give good prformence..


lookup gives more tuning performance

Explain the mapping variable usage example in informatica

1165

---

How many ways are there to create ports?

1332

---

What is sq transformation?

1163

---

What is transformation?

1099

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5675

---

What is exclusive and normal mode for repository services?

1144

---

What is option by which we can run all the sessions in a batch simultaneously?

1143

---

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

942

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

---

What are the different ways to implement parallel processing in informatica?

1423

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2159

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2131

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2136

---

What is meant by target load plan?

974

---

How to generate sequence numbers using expression transformation?

1089

---