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 load the name of the current processing flat file along with the data into the target using informatica mapping?
What are the reusable transforamtions?
lookup transformation with screenshots
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
What is partioning?how many types of partinings are there
What does update strategy mean, and what are the different option of it?
Explain about the concept of mapping parameters and variables ?
what is inline view?
What do you mean by channel change?
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
what is the complex transformation you used in informatica