Three date formats are there . How to change these three into
One format without using expression transformation ?
Answer Posted / isha_gtb
IIF(IS_DATE(col1,'dd/mm/yyyy'),to_date(col1,'dd-mm-yyyy),NULL)
Is_date to check the format
and to_date to change it to desired format
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to update source definition?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How we can create indexes after completing the loan process?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the different types of repositories created using informatica?
how tokens will generate?
Have you worked with/created Parameter file
Under what condition selecting sorted input in aggregator may fail the session?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
how we can load rejected record's at run time?(not through bad files)
How many ways are there to create ports?
Explain in detail scd type 2 through mapping.
What are the types of caches in lookup?
How can we handle two sessions in informatica?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you