how the data will be loaded while desiging the schema?which
one first (for e.g.-dimesions and facts)

Answer Posted / suraj kedia

The order of loading the schema is as below:

1)Dimension Table
2)fact table

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define mapping and session?

675


What can we do to improve the performance of informatica aggregator transformation?

715


Can you use flat files in Mapplets.

2311


Explain transaction control transformation in informatica

908


Why is sorter an active transformation?

758






Write the different tools in the workflow manager?

662


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1588


What are the reusable transformations?

779


What is informatica powercenter repository?

813


What is the way to execute pl/sql script using informatica mapping?

1081


wf dont have integration severances how you can run?

1617


Whats there in global repository

1347


Repository user profiles

1460


Separate from a database, an information bazaar, and an information stockroom?

701


What are the informatica performance improvement tips

705