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?

Answer Posted / davankumar

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

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2064


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2252


permutations of mapplet

2454


How to update source definition?

1031


How to do unit testing in informatica? How to load data in informatica ?

1048


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3812


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

949


how many types of dimensions are available in informatica?

997


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2099


In informatica workflow manager, how many repositories can be created?

1267


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1926


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2468


Tell me about Propagate functions in informatica

874


Mention some types of transformation?

991


What if the source is a flat-file?

1042