A mapping contains
(1) Source Table S_Time ( Start_Year, End_Year )
(2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
Answer / 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 |
What are the challenges of Dataware housing in the future?
What are the data movement modes in informatcia?
In which circumstances that informatica server creates Reject files?
Can we create multiple integration service on single repository?
server hot-ws270 is connect to Repository B. What does it mean?
Enterprise data warehouse your projects phase by phase explain?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
What are the types of maping wizards that r to be provided in Informatica?
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
how to connect two or more table with single source qualifier?