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
- 4799 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 |
Clarify the utilization of aggregator cache record?
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
explain about unit testing? in real time?
Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks
How to create Target definition for flat files?
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
How to use procedural logic inside infromatica?
can anyone explain me about sales project in informatica?
can we import source table without using source qualifier? if yes then how? if no then why?
In Which scenario did u used Incremental loading?
How can we handle two sessions in informatica?
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
Teradata 
