Answer Posted / kt

If we miss to enable any of the port as GROUP BY, the
aggregator will write the lat row of the table to the next
trnasformation.

What is the different lookup cache(s)?

1086

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2747

---

What is a surrogate key?

1083

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1688

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9827

---

explain one complex mapping with logic? sales project?

6670

---

What is a difference between complete, stop and abort?

1083

---

While migrating the data from one environment to another environment how would you manage the connections?

1090

---

What is a stored procedure transformation?

1056

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10170

---

EXL informatica Questions

1390

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2201

---

Different sorts of metadata that stores in the storage facility?

1012

---

What do mean by local and global repository?

1226

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2457

---