Answer / rkumar.etl

yes in single mapping we can have 5 sources and 5 target and
we need to arrange target load plan if dependency exists.

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,

---

Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers  

---

How will the document be delivered to me?

0 Answers  

---

What are the basic needs to join two sources in a source qualifier?

3 Answers  

---

While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  

---

What is the Process to creating lookup transformation in informatica

0 Answers   Informatica,

---

Explain the difference between mapping parameter and mapping variable?

0 Answers  

---

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,

---

Explain in detail scd type 2 through mapping.

0 Answers  

---

What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,

---

What is a data modeling?

2 Answers  

---

Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,

---