Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 5120 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Difference between Target-based loading and constraint-based loading?
What is the benefit of session partitioning?
Which version configuration tool used in ur project?
How do you update the records with or without using update strategy?
COM components can be used in Informatica
permutations of mapplet
How do you load alternate records into different tables through mapping flow?
Why is sorter an active transformation?
generate date / time dimension in informatica
What are different types of transformations available in informatica?
define galaxy repository in informatica
What is a predefined event?
Tell me about Propagate functions in informatica
How can we remove the duplicates from flat file source?
How do you load only null records into target? Explain through mapping flow.
