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
- 5108 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
What is a router transformation?
How will the document be delivered to me?
What is the meaning of decode in informatica?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is the difference between a repository server and a powerhouse?
What is data movement mode in Informatica and difference between them?
What is a passive transformation?
What is mapping debugger?
Can we get 1st record through Informatica(without sequence number).
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is a filter transformation and why it is an active one?
Explain the pipeline partition with real time example?
What is a standalone command task?
How to generate sequence numbers without using the sequence generator transformation?
How do you migrate data from one environment to another?
