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

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6174


How do you remove duplicate records in informatica? And how many ways are there to do it?

1165


explan ur project architecture?

2066


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2003


What is the need of an ETL tool?

1086


State the differences between sql override and lookup override?

1203


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2003


What are the advantages of informatica?

1008


How do you load unique records into one target table and duplicate records into a different target table?

1247


How to call shell scripts from informatica?

995


How can one identify whether mapping is correct or not without connecting session?

1445


r u done any partitions in ur project?

1827


What is DR strategy for Informatica project?

1178


What is deployment group?

1211


What is the surrogate key?

1258