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

What is a candidate key?

7 Answers   CTS,

---

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,

---

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

---

Write the unconnected lookup syntax and how to return more than one column.

0 Answers  

---

What is resilience time?

0 Answers  

---

---

what is incremantal aggregation?

1 Answers  

---

What is the function of look up transformation?

0 Answers  

---

What is a shortcut and copy in Informatica and how two are different with each other?

0 Answers  

---

what is materialized view?

2 Answers  

---

what are presession,postsession success and postsession failure commands ?

1 Answers  

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

0 Answers  

---

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,

---