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
What is the use of source qualifier?
What are the different types of repositories created using informatica?
How can we handle two sessions in informatica?
What is sorter transformation?
What are mapplets?
What are the types of data warehouses?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain incremental aggregation in informatica
how to create user defined function (udf) in informatica
What is meant by a domain?
Explain the shared cache and re-cache?
Can we get 1st record through Informatica(without sequence number).
Which transformation is needed while using the Cobol sources as source definitions?
What is confirmed fact in dataware housing?
What is decode in informatica?