Answer / sanjay

Informatica issue a status code when it's run the stored
precedure transformation , it is use for error handling of
store procedure .

Answer / usha

Status code provides error handling facility.

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,

---

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,

---

Explain the aggregator transformation?

0 Answers  

---

how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,

---

Can you copy the session to a different folder or repository?

2 Answers  

---

How to differentiate between the active and passive transformations?

0 Answers  

---

In which circumstances that informatica server creates Reject files?

2 Answers  

---

WHAT IS FACT TABLES?

2 Answers  

---

Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

---

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

6 Answers   IBM,

---

what is metadata?

8 Answers   Satyam,

---

What is a snowflake schema?

0 Answers  

---