Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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?



In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and ..

Answer / davankumar

To_char(date,formatedate) in the expression t/r

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Informatica Interview Questions

Explain scd type 3 through mapping.

0 Answers  


Describe two levels in which update strategy transformation sets?

1 Answers  


What are Dimensional table?

0 Answers   Informatica,


What is transformation?

0 Answers  


What are ETL Tools?

0 Answers   Informatica,


How to elaborate powercenter integration service?

0 Answers  


What is the way to execute pl/sql script using informatica mapping?

0 Answers  


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?

0 Answers  


Define sessions in informatica etl?

0 Answers  


where is the reject loader .

1 Answers  


What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,


how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,


Categories