How will u find weather dimension table is big in size of a
fact table?
Answer / 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 |
What are the mapping paramaters and mapping variables?
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
How the dimensions will be loaded?
What is the difference between router and filter?
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
What is facttable granularity?
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
How does the aggregator transformation handle null values?
what is session parameters?
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
How to view and Generate Metadata Reports?