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
- 5198 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 |
i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500
What are the scheduling options to run a sesion?
how to call lookup qualifer in unconnected look;up
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
what is the difference between Informatica7.1 & informatica 8.1
Can we create a Integration service without a Repository service and vice versa?
What is target load order?
What are reusable transformations in how many ways we can create them?
How to create a non-reusable instance of reusable transformations?
Teradata 
