A mapping contains
(1) Source Table S_Time ( Start_Year, End_Year )
(2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
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
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is a surrogate key?
What does command task mean?
Can you use flat files in Mapplets.
What is joiner change?
How to do the error handling of if ur source is flatfiles?
How to use procedural logic inside infromatica?
Why union transformation is an active transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is the use of an aggregator cache file?
Differentiate between sessions and batches?
what is the complex transformation you used in informatica
Can we get 1st record through Informatica(without sequence number).
What is pmcmd command?
Define update strategy?