Answer Posted / srinu

surrogate key is a System generated Key ( Artificial
key ),Every join between dimension tables and fact tables
in a data warehouse environment should be based on
surrogate keys, not natural keys.
There are still more reasons to use surrogate keys. One of
the most important is the need to encode uncertain
knowledge. You may need to supply a customer key to
represent a transaction, but perhaps you donýt know for
certain who the customer is. This would be a common
occurrence in a retail situation where cash transactions
are anonymous, like most grocery stores.
What is the customer key for the anonymous customer?
Perhaps you have introduced a special key that stands for
this anonymous customer. This is politely referred
to as a "hack."

What is aggregate cache in aggregator transformation?

1126

---

What is the difference between informatica 7.0 and 8.0?

991

---

Which transformation should we use to normalise the COBOL and relational sources?

1182

---

How many ways are there to do 'remove duplicate records in informatica'?

989

---

is it possible to index the data in cache of lkp transformation ?

2018

---

Write the advantages of partitioning a session?

1259

---

What is workflow monitor?

1044

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7166

---

What will be the approach?

963

---

Performance tuning in UNIX for informatica mappings?

2549

---

Why is sorter an active transformation?

1101

---

Explain the use of aggregator cache file?

1239

---

What is powercenter on grid?

1166

---

How does a sorter cache works?

1045

---

Is there any target staging area in informatica not staging area

2556

---