Tell me how many tables used in Ur project and how many fact
tables and dimension tables
used in ur project

Answer Posted / davankumar

Actuvally...that can be dependinge ur project...but u have
2 say like these..In my project we have more than 100
tables but in my module we can used only 10 to 15 tables
only..
Then dimension :5 to 6 dimension tables
And 1 or 2 fact tables

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe an informatica powercenter?

609


Explain target update override in informatica

635


What is workflow manager?

579


I have a flat file, want to reverse the contents of the flat file

700


Reusable transformation and shortcut differences

1383






can anyone suggest best free Talend data integration training online

1264


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1564


What is a repository? And how to add it in an informatica client?

664


How to start a workflow using pmcmd command?

715


tell me 5 session failure in real time how can you solve that in your project?

1634


What are the types of schemas we have in data warehouse.

535


While importing the relational source definition from the database, what are the metadata of source that will be imported?

797


What is the need for an etl tool?

641


Write the prerequisite tasks to achieve the session partition?

654


What are connected or unconnected transformations?

631