Generally how many Fact Tables and Dimensions Table you
have used in the Project?
Which one is loaded first Fact Table or Dimensions Table
into the warehouse?
What is the size of the Fact Table and Dimension Table?
what is the size of the table and warehouse

Answer Posted / rajupatel

Dimension will be loaded first then fact,
Table size: Dimenstion > fact
Number of Records: fact > dimention
Size: Table < DWH

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the procedure for creating independent data marts from informatica 7.1?

539


Explain what are the different types of transformation available in informatica.

535


How to start a workflow using pmcmd command?

689


What is the sequence generator transformation in informatica?

585


How many ways are there to create ports?

686






Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

1815


In informatics server which files are created during the session rums?

608


what is the -ve test case in your project.

1825


What are the settings that you use to configure the joiner transformation?

588


Explain lookup transformation source types in informatica

670


How many input parameters can exist in an unconnected lookup?

961


What do you understand by SOA of Informatica?

568


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1741


What are roles and groups and benefits of using them?

543


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1674