Answer / j.david sukeerthi kumar

Hi

Informatica repository is a central meta-data storage place,
which contains all the information which is necessary to
build a data warehouse or a data mart.

Meta-data like source def,target def,business
rules,sessions,mappings,workflows,mapplets,worklets,database
connections,user information, shortcuts etc

Answer / purna

Repository is Brain of Informatica.
In every project must and should to use one or more repository.
It is metadata object

Explain reference cursor?

1 Answers  

---

What is a diff between joiner and lookup transformation

16 Answers   CTS, Satyam, TCS, UHG,

---

What is union transformation?

0 Answers  

---

I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?

3 Answers   ITC Infotech, TCS,

---

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  

---

Explain the types of transformations?

0 Answers  

---

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

---

which one is better either active or passive transformation in informatica

1 Answers  

---

Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers  

---

Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,

---

plz plz plz send client names and project names in informatica?

1 Answers  

---

How to update source definition?

0 Answers  

---