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
- 4500 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 |
I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..
What is pmcmd command?
How do you load first and last records into target table?
what is dimension table?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
Name 4 output files that informatica server creates during session running?
how u know when to use a static cache and dynamic cache in lookup transformation.
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
can we generate reports in informatica ? How?
Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai
which one is better performance wise joiner or look up
Teradata 
