A mapping contains
(1) Source Table S_Time ( Start_Year, End_Year )
(2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
- 1 Answers
- 3939 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
Make a note of the quantity vaults made in informatica?
How can we use mapping variables in informatica?
What are the tasks that can be performed using sq?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Explain the different kinds of facts.
Differences between connected and unconnected lookup?
What you know about transaction control transformation?
How might you approve all mappings in the archive all the while?
lookup transformation with screenshots
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How do you load only null records into target?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is a filter transformation?
How big was your fact table
How to partition the Session?
