Does Facttable Normalized or Denormalized?
Answers were Sorted based on User's Feedback
Fact tables are normalized. Dimension tables are denormalized
| Is This Answer Correct ? | 27 Yes | 0 No |
source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
what is a transforamation?
How to improve the performance of Aggregate transformation?
What is the difference between a shortcut of an object and copy of an object? Compare them.
can we override a native sql query within informatica? How do we do it?
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
Explain the etl program with few examples.
How can you generate reports in informatica?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is sorter transformation?