Answer Posted / shashikiran

If it is horizontal join then we should use joiner transformation having common columns in both the flat files if it is more than 3 flat files, then number of joiners will no. of flat files - 1 i.e,
if suppose there are 4 flat files then 3 joiners are used.
If the flat files structure is same then we can go for vertical joining by using Union transformation or by using indirect file loading concept.

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

3921

---

How do you convert single row from source into three rows into target?

1208

---

Can we create a Integration service without a Repository service and vice versa?

1255

---

Explain lookup transformation in informatica

1123

---

What is decode in static cache?

1259

---

What is persistent lookup cache?

1092

---

What is union transformation?

1015

---

Which transformation should we use to normalise the COBOL and relational sources?

1267

---

How to elaborate tracing level?

1217

---

Differences between version 7.x and 8.x.

1939

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1096

---

What is the scenario which compels informatica server to reject files?

1118

---

What can we do to improve the performance of informatica aggregator transformation?

1139

---

Clarify the aggregator change?

1076

---

How can we use mapping variables in informatica? Where do we use them?

1280

---