Answer Posted / rajesh aitha

We should ask a question here, do u want the location appended or the rest of the field appended to target if a record with same location is arrived next time?


sort based on location, Next use the logic in expression transformation to check the previous record location and next record location, if same then out put the concatenated values with first answer logic as explained here. Apply the same if required for rest of the fileds.

How to join three sources using joiner?

1028

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2304

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

988

---

How to load a Dimension ? and how to load a fact table?

1369

---

What are the new features of Power Center 5.0?

1698

---

Can you use flat files in Mapplets.

2609

---

During the running session, output files are created by informatica server. Enlist few of them.

929

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1428

---

Can we create two repositories on same database instance in oracle?

1014

---

What is rank transform?

940

---

Is there any way to read the ms excel datas directly into informatica?

977

---

Explain your project of banking domian.

1605

---

What is union transformation in informatica?

1096

---

Is it possible to create multiple domains on a single Informatica server?

1179

---

What is the difference between a connected look up and unconnected lookup?

910

---