Answer / akhil4

infromatica product known as informatica power center.it consist of 3components
1.informatica power center client tools
in this we have
a.designer
b.repository manager
c.work flow manager
d.work flow monitor
2.informatica power center repository
3.informatica power center server

What are the types of metadata that stores in repository?

2 Answers  

---

What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

3 Answers   Logica CMG,

---

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,

---

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,

---

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

---

---

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 Answers   Accenture, CSC,

---

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

0 Answers  

---

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

---

Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,

---

where to select code page option?

2 Answers   TCS,

---

What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,

---

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

5 Answers   TCS,

---