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 is main use of mapplet?

1133


Can we create a Integration service without a Repository service and vice versa?

1215


What are the differences between joiner transformation and source qualifier transformation?

1173


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2723


what is $$$$?

2161


How union transformation is used?

1006


What is dimensional table?

1067


How to Create a folder using pmrep command?

1177


How to elaborate tracing level?

1180


Can we change Dynamic to Static or Persistent cache? If so what happens?

2211


What is the benefit of session partitioning?

1116


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2132


What do you mean incremental aggregation?

1077


Under what conditions selecting sorted input in aggregator will still not boost session performance?

1080


How to start a workflow using pmcmd command?

1253