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

Generally how many Fact Tables and Dimensions Table you
have used in the Project?
Which one is loaded first Fact Table or Dimensions Table
into the warehouse?
What is the size of the Fact Table and Dimension Table?
what is the size of the table and warehouse

Question Posted / sri

Answers were Sorted based on User's Feedback



Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is lo..

Answer / ranjan

it depends upon the requirement of the client . dimension
table is loaded first , using the primary keys of the
dimension table , fact tables are loaded .size of the fact
and dimension table also depends upon the requirement .
size of the table and warehouse also depends upon clients
requirement .

Is This Answer Correct ?    17 Yes 2 No

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is lo..

Answer / abhishek

ranjan is right its all depend on that how many years old
data u are going to keep in your warehouse
first dimension will load and then on base of dimension we
load fact table

Is This Answer Correct ?    10 Yes 0 No

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is lo..

Answer / rajupatel

Dimension will be loaded first then fact,
Table size: Dimenstion > fact
Number of Records: fact > dimention
Size: Table < DWH

Is This Answer Correct ?    10 Yes 1 No

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is lo..

Answer / dhana

Can anyone please tell me the No. of Fact table & Dimension tables usually used in a prjoect?I just need an example.Also the size of data warehouse?Is it in Terabyte of something?I just need an approximate size.
Thanks

Is This Answer Correct ?    0 Yes 0 No

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is lo..

Answer / bsgsr

hi, raju patel.

ur answers are thoughtful. they reflect ur intellect which
is very stimulating and vibrant. i am pretty impressed with
your answers.

i believe you have good experience with the industry. since
when have you been working with the industry. can i have
some of my queries cleared only if you dont
minddddddddddddddddd!!!!!!!!!!!!. revert back to me on my
id bsgsr12@gmail.com also provide me your number if you
dont mind. take care

Is This Answer Correct ?    1 Yes 10 No

Post New Answer

More Informatica Interview Questions

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

What is resilience time?

0 Answers  

write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010

2 Answers   Accenture,

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers   IBM, TCS,

what is plsql table?

2 Answers  




how do u move the code from development to production?

3 Answers  

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,

How mapping parameter and variable works

1 Answers  

Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

2 Answers   CTS,

What is informatica metadata and where is it stored?

0 Answers  

can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

For more Informatica Interview Questions Click Here
Categories