Interested to Buy Any Domain ? << Click Here >> for more details...
A mapping contains
(1) Source Table S_Time ( Start_Year, End_Year )
(2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
- 1 Answers
- 4694 Views
- I also Faced
- E-Mail Answers
Answer Posted / pati
Day = to_char(sysdate,'Day')
Date = to_char(sysdate,'DD')
Month = to_char(sysdate,'Month')
Year = to_char(sysdate,'YYYY')
Quater = to_char(sysdate,'Q')
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is the difference between a repository server and a powerhouse?
How do you migrate data from one environment to another?
What is olap (on-line analytical processing?
How to generate sequence numbers?
What is pmcmd command?
Does an informatica transformation support only aggregate expressions?
waht type of interface is used for testing the data in informatica
what is the hint? how to use it to reduce the query processing in program?
How to open an older version of an object in the workspace?
Differentiate between reusable transformation and mapplet.
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are data-driven sessions?
Define pmcmd command?
What is incremental aggregation?
What are the restrictions of union transformation?
