if we are extracting 600000 records from a source table so how much volume of

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.

Question Posted / prgn

2 Answers
5805 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

if we are extracting 600000 records from a source table so how much volume of records frequently ..

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

if we are extracting 600000 records from a source table so how much volume of records frequently ..

Answer / akash

The question is not clear...

Is This Answer Correct ?

1 Yes

1 No

Post New Answer

More Informatica Interview Questions

What is the difference between router and filter?

0 Answers

what is confirmed fact?

2 Answers

what is target load plan

2 Answers Cap Gemini,

Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers Infotech,

What are the tasks that can be performed using sq?

0 Answers

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

0 Answers IBM,

If informatica has its scheduler why using third party scheduler?

0 Answers

Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek

5 Answers CSC,

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

6 Answers IBM,

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

0 Answers

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers Motorola,

For more Informatica Interview Questions Click Here