Interested to Buy Any Domain ? << Click Here >> for more details...
Does Facttable Normalized or Denormalized?
- 2 Answers
- 8057 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Fact tables are normalized. Dimension tables are denormalized
| Is This Answer Correct ? | 27 Yes | 0 No |
Explain the flow of data in Iinformatica?
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
Slowly changing dimensions, types and where will you use them
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
What is difference between stored procedure transformation and external procedure transformation?
how we load the data from source to staging area
Briefly define reusable transformation?
What are the components of workflow manager?
How to create the source and target database connections in server manager?
guys which is the best institute in banglore to learn informatica??
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
Teradata 
