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.
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 |
What is workflow variable? When we use workflow variable? Can any one explain me with one example???
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
how eliminate the duplicates in flat file with out using sorter ,aggregater
What are the mapping parameters and mapping variables?
What is a stored procedure transformation?
What is the difference between normal and bulk loading? Which one is recommended?
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com
which transformation uses cache?
Plz..let me know differences between Informatica 7.1 and 8.1?
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
Can you start a session inside a batch individually?
What are the features of complex mapping?