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

What is the Process to creating lookup transformation in informatica

587


What is the use of transformation?

576


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1660


What is the advantage of informatica?

650


What is intricate mapping?

594






What do you understand by SOA of Informatica?

592


How to start a workflow using pmcmd command?

715


What do you understand by a term domain?

670


How can repository reports be accessed without sql or other transformations?

730


What is meant by lookup transformation?

616


Can you generate sequence numbers without using the sequence generator transformation?

603


How are the sources and targets definitions imported in informatica designer?

672


What is target designer and target load order?

660


Explain the different lookup methods used in informatica?

589


what is the size of your data warehousing?

1675