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
Explain how to import oracle sequence into informatica?
Global and Local shortcuts. Advantages.
Please let me know how to make Data masking in informatica..
What does update strategy mean, and what are the different option of it?
How identifying bottlenecks in various components of informatica and resolving them?
How can we use mapping variables in informatica? Where do we use them?
How do you promote a non-reusable transformation to reusable transformation?
What are the types of schemas we have in data warehouse.
What are mapplets?
tell me 5 session failure in real time how can you solve that in your project?
How many input parameters can exist in an unconnected lookup?
What are the different types of transformation available in informatica.
can we override a native sql query within informatica? Where do we do it?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?