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 |
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
What are the issues you have faced in your project? How did you overcome those issues?
In Which scenario did u used Incremental loading?
where does the default group roew in a router is stored what is the default size of memory in router
Explain factlessfact table with scenario
What are mapplets?
in a table it has 200 rows the query is select 150 from tablename.whats the output
What does cheating measurement mean?
What is data merging, data cleansing and sampling?
why we use source qualifier transformation?
hw cn v elimate dublicate values from lookup without overriding sql?
How you load distinct records into one target and duplicate records into another target?