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 are the main issues while working with flat files as source and as targets ?

1096

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1986

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1932

---

What is the difference between writing a joiner query in ANSI style and THETA style?

2320

---

permutations of mapplet

2454

---

How to call shell scripts from informatica?

935

---

Explain pushdown optimization and types in informatica

1015

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1133

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1031

---

Explain the difference between mapping parameter and mapping variable?

979

---

What is the maplet?

1040

---

What are the designer tools for creating transformations?

1047

---

EXL informatica Questions

1310

---

What are the modules in Power Center

1621

---

What could be the possible resons of locks by user?

1033

---