1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / dhana

Answer Posted / dhana

Can anyone please tell me the No. of Fact table & Dimension tables usually used in a prjoect?I just need an example.Also the size of data warehouse?Is it in Terabyte of something?I just need an approximate size.
Thanks

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the way to execute pl/sql script using informatica mapping?

966

What is a filter transformation?

573

r u done any partitions in ur project?

1407

what is mean by complex business rule ?

1723

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4793




Explain transaction control transformation in informatica

763

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1412

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

1691

differences between service based and product based?

1568

What do mean by local and global repository?

707

can you please explain me pre session and post session options?

6387

Explain load alternative records / rows into multiple targets - informatica

693

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1468

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1533

What is mapping debugger?

574