Interested to Buy Any Domain ? << Click Here >> for more details...
How do we do the Fact Load
What is the size of your Data warehouse?
What is your Daily feed size and weekly feed size
- 1 Answers
- 7907 Views
- I also Faced
- E-Mail Answers
Answer / rameshreddy
After dimension load takes place we can load the Fact tables.
and
size of data warehouse for small projects 100-500gb
medium projects 500-1000gb
large projects 1000-N gb
| Is This Answer Correct ? | 3 Yes | 0 No |
What is a stored procedure transformation?
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
sample mappings for scd1,scd2 and scd3
What is depict expression change?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
What is difference between Mapplet and reusable transformation?
What are the different ways to implement parallel processing in informatica?
why we are using surogate key in real time give me explanation
Which kind of index is preferred in DWH?
wht is full process of Information source to target just like stg to productuon and development
What are the associated ports in look up T/R.
What is the status code in stored procedure transformation?
Teradata 
