every DWH must have time dimension
so now what is the use of the time dimension
how we can calculate sales for one month,half-yr'ly,and
year'ly?how we are doing this using time dimension.



every DWH must have time dimension so now what is the use of the time dimension how we can calcu..

Answer / ravi

BY TAKING THE TIME DIMENSION TO EXPRESSION TRANSFORMATION
AND CREATE NEW PORTS AND MAKE THE NEW PORTS AS OUTPUT PORTS

WRITE CONDITION IN THE NEW PORTS BY USING THE FUNCTION
GETDATE_PART(DATE DIMENSION)

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,


What is the procedure to load the fact table.Give in detail?

1 Answers  


how remove 1st 3 records & last 3 records in informatics

4 Answers   TetraSoft,


What is xml source qualifier transformation in informatica?

0 Answers  


How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?

1 Answers  






Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it

1 Answers  


What is source qualifier?

6 Answers   SDS,


What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,


How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 Answers  


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

0 Answers  


what is bridge tables in informatica

1 Answers   CTS,


What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,


Categories