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?
Answer / davankumar
To_char(date,formatedate) in the expression t/r
| Is This Answer Correct ? | 3 Yes | 0 No |
Explain scd type 3 through mapping.
Describe two levels in which update strategy transformation sets?
What are Dimensional table?
What is transformation?
What are ETL Tools?
How to elaborate powercenter integration service?
What is the way to execute pl/sql script using informatica mapping?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Define sessions in informatica etl?
where is the reject loader .
What is the difference between writing a joiner query in ANSI style and THETA style?
how lookup is acting as both active and passive ? how is it possitble?