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

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.

Question Posted / guest


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

How will the document be delivered to me?

0 Answers  

Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,

how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)

6 Answers   Accenture,

Please let me know how to make Data masking in informatica..

0 Answers  

How is Data Models Used in Practice?

1 Answers  




Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  

what is runtime variable?

3 Answers   TCS,

how did u understand business requirement?

2 Answers   TCS,

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,

version controlling in informatica?

3 Answers  

What is the status code in stored procedure transformation?

0 Answers   Informatica,

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

For more Informatica Interview Questions Click Here
Categories