The order of loading the schema is as below: 1)Dimension Table 2)fact t

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

Question Posted / suraj kedia

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

Please Help Members By Posting Answers For Below Questions

Which transformation should we use to normalise the COBOL and relational sources?

1182

What is session task and command task?

1264

What do you understand by SOA of Informatica?

964

Whats the difference between informatica powercenter server, repositoryserver and repository?

1159

What is a surrogate key?

1064

According to his methodology what all you need before you build a datawarehouse

1741

How to convert multiple rows to single row (multiple columns) in informatica

1366

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1025

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1110

What does update strategy mean, and what are the different option of it?

1082

Differentiate between a database and data warehouse?

1128

What is meant by LDAP users?

1173

How to generate sequence numbers?

1071

Explain the code page compatibility?

1051

Where are the source flat files kept before running the session?

1057