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



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

Post New Answer

More Informatica Interview Questions

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  


please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

1 Answers   Accenture,


We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  


i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,


Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

1 Answers   Accenture, Patni,






what is constraint based load order

2 Answers   Cap Gemini,


performance wise which one is better in joiner and lookup transformation?why?explain clearly?

1 Answers   IBM,


What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers   CTS,


Whats the difference between $, $$, $$$

9 Answers  


what are the Methods For Creating Reusable Transformations?

0 Answers   Informatica,


My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,


have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,


Categories