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
- 4795 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
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is the benefit of session partitioning?
Explain joiner transformation in informatica
Explain the pipeline partition with real time example?
How are the sources and targets definitions imported in informatica designer?
What is the use of source qualifier?
what is the size of your data warehousing?
Explain the aggregator transformation?
How big was your fact table
What are the different versions of informatica?
How many ways are there to do 'remove duplicate records in informatica'?
What the difference is between a database, a data warehouse and a data mart?
If informatica has its scheduler why using third party scheduler?
What is rank transformation?
