if we are extracting 600000 records from a source table so
how much volume of records frequently we load in warehouse.
(Iknow its depend on client requirement) still i want to
know how much volume of records store in warehouse.
Answers were Sorted based on User's Feedback
Answer / guest
u told its based on clients requirment only.then wat boss?
thats the answer.if he needs only one record we wil load
only one record. if he need 599999 record to be in target
we wil do that. its based on how we create dimension and
fact in data warehoue. ultimately al our data has to help
the client to see the needed data and to analyse and to
take strategic decisions from it.
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the guidelines to be followed while using union transformation?
what is DSS?
wht is cdc?how to use it in creation of mappings?
What is the difference between view and materialised view?
Which kind of index is preferred in DWH?
what is diff b/t sorter t/r and agg have the option sorter property...
what is the function of 'F10' informatica ?
What is data movement mode in Informatica and difference between them?
how lookup is acting as both active and passive ? how is it possitble?
how to work with mapplet designer in informatica?
How you prepared reports for OLAP?
what is INFORMATICA TESTING process