Answer Posted / romi

Thanks to all,

But i want to store first half data in 1 table and another
half in another table. and with procedure i m getting
alternative data.

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

1402

---

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?

1473

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1260

---

How to elaborate tracing level?

1152

---

What the difference is between a database, a data warehouse and a data mart?

1137

---

How to use procedural logic inside infromatica?

1196

---

EXL informatica Questions

1358

---

How to update a particular record in target with out running whole workflow?

1568

---

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

2728

---

How to differentiate between the active and passive transformations?

1136

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1106

---

What is the status code in stored procedure transformation?

1163

---

How does the aggregator transformation handle null values?

1128

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1935

---

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

1217

---