how to load dimension table and fact table. plz tell me the steps.

2094

Where do we use mapping variables in informatica?

1065

can u any challenge your project?

2033

How to partition the Session?

1113

Slowly changing dimensions, types and where will you use them

1713

How does a rank transform differ from aggregator transform functions max and min?

1205

What if the source is a flat-file?

1111

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1909

Design a mapping to load a target table with the following values from the above source?

1346

How is union transformation utilized?

1009

 Informatica Checkpoints

3330

can we override a native sql query within informatica? How do we do it?

1126

What are the advantages of informatica?

1014

What is meant by lookup transformation?

1110

What are the new features of Power Center 5.0?

1779