Does Facttable Normalized or Denormalized?

Question Posted / rakeshm4119

Answers were Sorted based on User's Feedback

Does Facttable Normalized or Denormalized?..

Fact tables are normalized. Dimension tables are denormalized

Is This Answer Correct ?

27 Yes

0 No

Does Facttable Normalized or Denormalized?..

Answer / hari prasad

fact tables contains normalized.

Is This Answer Correct ?

11 Yes

0 No

More Informatica Interview Questions

what is degenerated dimension table with scenario

i have source in oracle 10g,oracle 8i how will u take the data from two sources

what is SDLC way of code development?

How union transformation is used?

What is Data Caches size?

While migrating the data from one environment to another environment how would you manage the connections?

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

What are the different tools in workflow manager?

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

What is meant by target load plan?

What is olap (on-line analytical processing?

For more Informatica Interview Questions Click Here