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
- 5127 Views
- IBM, I also Faced
- E-Mail Answers
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 |
how can we perform incremental aggregation?explain with example?
what is runtime variable?
What is the session task and command task?
Explian the Process of deployment groups in informatica
Repository user profiles
How to create or import flat file definition in to the warehouse designer?
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
what is the size of your data warehousing?
How many repositories can we create in Informatica??
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
Why we need XMLs?
Teradata 
