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 |
one source to target loading insert new rows and update existing rows?
What is the procedure to load the fact table.Give in detail?
how remove 1st 3 records & last 3 records in informatics
What is xml source qualifier transformation in informatica?
How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
What is source qualifier?
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
what is bridge tables in informatica
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,