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
- 5199 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
Differentiate between router and filter transformation?
Name the different lookup cache(s)?
What are the transformations that are not supported in mapplet?
What is flashback table ? Advance thanks
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Make a note of the quantity vaults made in informatica?
What is different between the data warehouse and data mart?
What is a filter transformation and why it is an active one?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is an aggregator transformation?
What happens when a session fails and you click on recover?
What is union transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Enlist some properties of sessions.
