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.
Answer Posted / 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 |
Post New Answer View All Answers
Why filter transformation is an active one?
What is rank transformation?
What is complex mapping?
Explain what is informatica metadata and where is it stored?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is incremental aggregation?
What is target load order?
What is the session task and command task?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
design of staging area?
Which transformation should we use to normalise the COBOL and relational sources?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Different sorts of metadata that stores in the storage facility?
Write the different tools in the workflow manager?
What is the reusable transformation?