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
- 4617 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
How can a transformation be made reusable?
What is powercenter on grid?
Define sessions in informatica etl?
What are the main issues while working with flat files as source and as targets ?
What are the types of caches in lookup?
What could be the possible resons of locks by user?
What is a standalone command task?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Different qualification between a related rotate toward the sky and isolates look upward?
What is the difference between STOP and ABORT options in Workflow Monitor?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Why union transformation is an active transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Separate from a database, an information bazaar, and an information stockroom?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
