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
- 4720 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 sql query overwrite in source qualifier in informatica
According to his methodology what all you need before you build a datawarehouse
What are pre and post-session shell commands?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is the reusable transformation?
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?
How we can create indexes after completing the load process?
Define pmcmd command?
What is the format of informatica objects in a repository?
What are mapplets? How is it different from a Reusable Transformation?
Explain the different kinds of facts.
What is a transaction control transformation?
How would you join a node to the already existing domain?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is an Integration service in Informatica?
