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 / 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
what is the size of your data warehousing?
How to create Target definition for flat files?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is a difference between complete, stop and abort?
Explain the informatica workflow?
How many number of sessions can one group in batches?
Implementation methodology
Explain how many types of dimensions are available in informatica?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is xml source qualifier transformation in informatica?
How to generate sequence numbers?
How to elaborate powercenter integration service?
How to implement security measures using repository manager?
What is mapplet in informatica?