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
- 5024 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Define mapping and session?
How to call shell scripts from informatica?
How to elaborate powercenter integration service?
How do you change a non-reusable transformation to reusable transformation?
What is DR strategy for Informatica project?
Write the unconnected lookup syntax and how to return more than one column.
What are ETL Tools?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Define enterprise data warehousing?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How you can differentiate between connected lookup and unconnected lookup?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are some examples of informatica etl programs?
Enlist some properties of sessions.
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
