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
- 5114 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 do you manage the Parameter files while migrating your data from one environment to another environment?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How do you convert single row from source into three rows into target?
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?
What are the types of schemas we have in data warehouse.
why union transformation is active transformation?
How to load last n records of file into target table - informatica
what is polling?
How can you run a session without using server manager?
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
Performance wise which is better joiner or look up ? Give me with example?
Teradata 
