Answer / srinu

make required column as primary-forign key relation then add
fields wt do u want

Answer / vino

i Think,

You can split the dimension tables into two and can join
the two separate dimemsion tables by the surrogate key.

Answer / kittu

It is clearly apt for snowflake schema because in snow flake schema dimension table are further splits the de-normalized table into small normalized dimensions to decrease the table space and also to increase the performance this can be done with help on foreign key and primary key constraints

Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,

---

How to go to the older version for a mapping?

0 Answers  

---

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

---

How do you use reject loader.

0 Answers  

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

0 Answers  

---

Which will beter perform IIf or decode?

3 Answers   TCS,

---

pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

0 Answers   HCL,

---

How to implement security measures using repository manager?

0 Answers  

---

If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,

---

Explain informatica architecture - version 8 / 9

0 Answers   Informatica,

---

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

---

tell me 5 session failure in real time how can you solve that in your project?

0 Answers   CSC,

---