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...

I have table name called Team and I have name and DOJ in
that table in oracle, when I retrive the table in
Informatica DOJ shows with date and time , I want want to
know is it possible to get only date(MMDDYYYY) in the date
data type,

Answer Posted / bk

TO_CHAR(DOJ_port, 'MMDDYYYY')

Is This Answer Correct ?    14 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the reusable transformations?

1221


Explain the different lookup methods used in informatica?

1098


my source is junk data how will u remove that junk data by using unix please any one replay me

3755


What is substr in informatica?

1261


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1113


When do you use sql override in a lookup transformation?

1142


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5880


How to create a non-reusable instance of reusable transformations?

1170


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1128


What are the settings that you use to configure the joiner transformation?

1104


Can we create a node as a gateway node and the same node can be assigned to a grid?

1125


How to use procedural logic inside infromatica?

1323


What is dynamic cache?

1085


How do you take back up of repository?

1209


What is the use of source qualifier?

1186