A mapping contains
(1) Source Table S_Time ( Start_Year, End_Year )
(2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
- 1 Answers
- 3952 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
Is stop and abort are same in informatica?
How to use pmcmd utility command?
What is incremental aggregation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the types of schemas we have in data warehouse and what are the difference between them?
Can we override a native sql query within informatica?
Describe an informatica powercenter?
How can we remove the duplicates from flat file source?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What are the different types of transformation available in informatica.
Explain the code page compatibility?
How to load last n records of file into target table - informatica
Define filter transformation?
4 yrs etl devloper roles and responsibilities?any body give solutions
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
