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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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,

Question Posted / rajeshreshi

Answers were Sorted based on User's Feedback



I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the ..

Answer / bk

TO_CHAR(DOJ_port, 'MMDDYYYY')

Is This Answer Correct ?    14 Yes 0 No

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the ..

Answer / yashvi

You can use TRUNC function in exp transformation e.g
TRUNC(to_date(fieldname,'mmddyyyy')

Is This Answer Correct ?    6 Yes 0 No

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the ..

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

More Informatica Interview Questions

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

if we have a delimiters at unwanted places in a flat file how can we over come those.

0 Answers  

What are mapping parametres and variables in informatica?

6 Answers   TCS,

What is InformaticaPowerCenter?

0 Answers   Informatica,

What is up date strategy and what are the options for update strategy?

2 Answers  

What is surrogate key?

9 Answers  

Which version configuration tool used in ur project?

0 Answers   CTS, TCS,

what are 3 tech challenges/ common issues you face?

0 Answers   TCS,

Can you start a batches with in a batch?

1 Answers  

what is mean by throghput? in informatica

3 Answers   Cap Gemini,

Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  

What are the data movement modes in informatcia?

1 Answers  

For more Informatica Interview Questions Click Here
Categories