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

Is it possible to create multiple domains on a single Informatica server?

0 Answers  


Briefly define a session task?

0 Answers  


SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

6 Answers   IBM,


write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste

1 Answers   TCS,


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

0 Answers   IBM,


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

0 Answers  


if i am having 10 records in source, i want 20 records in target...how will you do it

13 Answers   BirlaSoft, IBM,


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  


what is fact and what types of fact tables is there

4 Answers   Cap Gemini,


Explain informatica architecture - version 8 / 9

0 Answers   Informatica,


Can any one explain or sujjest some sites for scd mappings.Thank you

1 Answers   Wipro,


I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,


Categories