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
What is the procedure for creating independent data marts from informatica 7.1?
Explain what are the different types of transformation available in informatica.
How to start a workflow using pmcmd command?
What is the sequence generator transformation in informatica?
How many ways are there to create ports?
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.
In informatics server which files are created during the session rums?
what is the -ve test case in your project.
What are the settings that you use to configure the joiner transformation?
Explain lookup transformation source types in informatica
How many input parameters can exist in an unconnected lookup?
What do you understand by SOA of Informatica?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are roles and groups and benefits of using them?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???