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 / srinu

oracle support range
Jan 1, 1753 AD
to
Dec 31, 9999 AD

in informatica
The default date display format is
DY MON DD HH 24:MI:SS YYYY.
When you specify a date display format,
it displays in the test window. An invalid date display
format is marked invalid.

if u not able to Understand,,,,

Please send the Question Clearly,,,,srinu

Is This Answer Correct ?    3 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

2159


Can we override a native sql query within informatica?

1034


How can we use mapping variables in informatica?

1061


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

3868


Define update strategy?

1219


Define filter transformation?

1095


How to update a particular record in target with out running whole workflow?

1576


Enlist the tasks for which source qualifier transformation is used.

1036


what is the hint? how to use it to reduce the query processing in program?

7828


what is the size of u r source(like file or table)?

2271


Explain direct and indirect flat file loading (source file type) - informatica

1318


What is the different lookup cache(s)?

1086


How would you join a node to the already existing domain?

1128


What are the differences between source qualifier and joiner transformation?

1060


What is exclusive and normal mode for repository services?

1142