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
Which transformation should we use to normalise the COBOL and relational sources?
What is session task and command task?
What do you understand by SOA of Informatica?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is a surrogate key?
According to his methodology what all you need before you build a datawarehouse
How to convert multiple rows to single row (multiple columns) in informatica
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What does update strategy mean, and what are the different option of it?
Differentiate between a database and data warehouse?
What is meant by LDAP users?
How to generate sequence numbers?
Explain the code page compatibility?
Where are the source flat files kept before running the session?