Answer Posted / moorthy g (ibm)

If your source is Flat file and Same Strcture then you can
go for indirect file type.
If source is relation file the you can use Source
Qualifier - Sql override or join condtion.
or Joiner Transformation(n-1)
=====
We Can join those tables in DB level.
(For Performance Tuning)

Explain incremental aggregation in informatica

1130

---

Explain about cumulative Sum or moving sum?

1043

---

Quickly characterize reusable change?

1119

---

How do you promote a non-reusable transformation to reusable transformation?

1138

---

What is sequence generator transformation in informatica?

1079

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5792

---

Explain lookup transformation source types in informatica

1098

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2146

---

What is rank transformation?

991

---

Plz can any one say me how to get the informatica certification materials and dumps

2049

---

waht type of interface is used for testing the data in informatica

2257

---

what is the complex transformation you used in informatica

2587

---

What is the use of transformation?

998

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2745

---

what is the Default Source Option For Update Strategy Transformation?

1240

---