Answer / swetha

Status code provides error handling for the informatica
server during the session. The stored procedure issues a
status code that notifies whether or not stored procedure
completed sucessfully. This value can not seen by the user.
It only used by the informatica server to determine whether
to continue running the session or stop.

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  

---

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,

---

In warehouses how many schemas are there?

0 Answers  

---

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 Answers  

---

What is use of batch file in informatica? How many types of batch file in informatica?

2 Answers   EXL,

---

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

---

Explain the aggregator transformation?

0 Answers  

---

How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,

---

write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

3 Answers   iGate,

---

what is data driven in informatica

5 Answers   IBM,

---

What are partitions in informatica and which one is used for better performance?

2 Answers  

---

What are the associated ports in look up T/R.

5 Answers   IBM, Zensar,

---