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 / ranjan

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1623

Explain joiner transformation in informatica

655

Is it possible to create multiple domains on a single Informatica server?

743

What is joiner transformation in informatica?

615

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

543




What is the cumulative sum and moving sum?

741

What is Session and Batches?

651

How can we improve session performance in aggregator transformation?

661

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5749

update strategy transformation in informatica

628

What is the Process to creating lookup transformation in informatica

574

Mention few power centre client applications with their basic purpose?

525

tell me about your project functionality

1856

What do think which one is the better joiner or look up?

712

Design time, run time. If you don't create parameter what will happen

1413