How will u find weather dimension table is big in size of a
fact table?

Answer Posted / tadikonda

if u have toad, u can find the tool option tab under that
ESTIMATE TABLE SIZE option,in that u can define the table
name and schema name ,in that way u can find which table is
big in size

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is stop and abort are same in informatica?

568


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1889


Define joiner transformation?

588


Separate from an archive server and a powerhouse?

487


What are the tuning techniques you applied during your last project

1556






State the limitations where we cannot use joiner in the mapping pipeline?

543


Could you explain what is enterprise data warehouse?

550


What are the settings that you use to configure the joiner transformation?

610


How many types of sessions are there in informatica.please explain them?

670


What is sequence generator transformation in informatica?

616


What is the sequence generator transformation in informatica?

609


what are the deliverables?in your project?

1648


What is the difference between source qualifier transformations source filter to filter transformation?

573


Separate from a database, an information bazaar, and an information stockroom?

601


Explain why we use partitioning the session in informatica?

607