Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

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

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

1 Answers   Cognizant,

"Change cache" in Informatica ?

2 Answers  

What is the session task and command task?

0 Answers  

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

0 Answers  

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,

What are the types of maping in Getting Started Wizard?

1 Answers  

what is parallel querying and what r hints.

1 Answers  

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers   IBM, Infotech,

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 Answers   Accenture, CSC,

For more Informatica Interview Questions Click Here
Categories