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


Please Help Members By Posting Answers For Below Questions

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1525


Write the unconnected lookup syntax?

652


Whats the difference between informatica powercenter server, repositoryserver and repository?

667


What are the different ways to implement parallel processing in informatica?

856


Global and Local shortcuts. Advantages.

1461






How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

707


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2062


If informatica has its scheduler why using third party scheduler?

765


What is the use of code page?

601


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1695


What are the components of Informatica? And what is the purpose of each?

614


What is the scenario which compels informatica server to reject files?

599


What is meant by incremental aggregation?

577


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

780


can anyone explain me about retail domain project in informatica?

7424