Answer / sai suresh

There are 3 types of data passing between informatica
server and stored proceduer these are
Input/Output parametors: Stored procedure it receive the
inputs and porvied the outputs.
Return Value:Ever data base to provied return value after
processing of stored procedure.
Status code: It is used for error handling.

why we need informatica

2 Answers   HCL,

---

What are the different threads in DTM process?

2 Answers  

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers   Cognizant, IBM,

---

what is a time dimension? give an example?

2 Answers   IBM,

---

how we can update a target table without update strategy and update override?

3 Answers   TCS,

---

What is an active transformation?

0 Answers   Informatica,

---

How does the server recognize the source and target databases. Elaborate on this.

1 Answers  

---

which one is better either active or passive transformation in informatica

1 Answers  

---

How to elaborate tracing level?

0 Answers  

---

Difference between Data and Index Caches?

0 Answers   Informatica,

---

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

---

What is router transformation

4 Answers   CSC,

---