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

Is there any way to read the ms excel datas directly into informatica?

0 Answers  

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers   TCS,

---

Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,

---

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,

---

list out all the transformations which use cache?

0 Answers   Informatica,

---

From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,

---

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

---

What is the reusable transformation?

0 Answers  

---

As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,

---

what is mean by throghput? in informatica

3 Answers   Cap Gemini,

---

What is a standalone command task?

0 Answers  

---

What is aggregate cache in aggregator transformation?

0 Answers   Informatica,

---