In CSV flat file date are in the following format.
dd/mm/yyyy (05/01/2005)and
d/m/yyyy (5/1/2005) and
dd/m/yyyy (05/1/2005) and
d/mm/yyyy (5/01/2005). It should be load to target
in a unique format. How will you implement this?
- 1 Answers
- 4291 Views
- I also Faced
- E-Mail Answers
Answer / davankumar
To_char(date,formatedate) in the expression t/r
| Is This Answer Correct ? | 3 Yes | 0 No |
Enlist few areas or real-time situations where informatica is required.
What is informatica worklet?
Three date formats are there . How to change these three into One format without using expression transformation ?
Is there any model difference between ODS and DWH
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
What do think which one is the better joiner or look up?
what is fact table?
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
what are challenges that you faced in testing? give solution to it?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Define mapplet?
Teradata 
