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
How many number of sessions can one group in batches?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Design a mapping to load a target table with the following values from the above source?
What are the popular informatica products?
In informatica workflow manager, how many repositories can be created?
What are the types of presistent cache in look up tr.
Differentiate between source qualifier and filter transformation?
What is transformation?
How to join three sources using joiner?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Which are the different editions of informatica powercenter that are available?
What will be the approach?
How to do the error handling of if ur source is flatfiles?
What is status code in informatica?