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
What are the tasks that can be performed using sq?
What are the guidelines to be followed while using union transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Please let me know how to make encryption and decryption with example?
What is the meaning of up gradation of repository?
Briefly define reusable transformation?
What are the new features of informatica 9.x developer?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
When do you use sql override in a lookup transformation?
What is informatica?
What is event and what are the tasks related to it?
tell me the rules and responsblites in our project(my project is development)
Mention some types of transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How does the aggregator transformation handle null values?