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 load alternative records / rows into multiple targets - informatica

0 Answers   Informatica,


Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,


when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  


What is the Difference between PowerPlay transformer and power play reports?

1 Answers  


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

0 Answers  


what are the settiings that u use to cofigure the joiner transformation?

2 Answers  


What if the source is a flat-file?

0 Answers  


What is log file,and where is it located,why u r using the log file

1 Answers   TCS,


.prm wirh repalce .txt is possible?

2 Answers  


What does reusable transformation mean?

0 Answers  


how to duplicates from expression transformation without using sorter before that

1 Answers  


i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

1 Answers   Mind Tree,


Categories