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
- 4796 Views
- I also Faced
- E-Mail Answers
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 |
Explain the shared cache and re-cache?
how the informatica server sorts the strings values in rank transformations?
when we dont use aggregator in mapping ?
can we import source table without using source qualifier? if yes then how? if no then why?
Explain what is informatica metadata and where is it stored?
What is Performance tuning in Informatica?
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
What is transformation?
How to list Top 10 salary, without using Rank Transmission?
Whats the difference between $, $$, $$$
what is the size of your data warehousing?
Teradata 
