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 |
if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target
What are the basic needs to join two sources in a source qualifier?
why union is active transformation?
Explain pushdown optimization $pushdownconfig parameter - informatica
How to load the source table into flat file target(with columns) in informatica?
How to create or import flat file definition in to the warehouse designer?
How do you handle decimal places while importing a flatfile into informatica?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How to display First letter of Names in Caps?
What are the measure objects?
what is meant by data driven.. in which scenario we use that..?
can u give example for factless fact table