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

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers   IBM, Patni, TCS,

What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,

Scheduling properties,whats the default (sequential)

0 Answers  

How many ways are there to do 'remove duplicate records in informatica'?

0 Answers  

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

0 Answers  

What are multi-group transformations?

0 Answers   Informatica,

Do joiner transformation use cache? If so describe?

2 Answers   Patni,

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

What are the new features of Power Center 5.0?

0 Answers  

what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,

How can you recover the session in sequential batches?

1 Answers  

For more Informatica Interview Questions Click Here
Categories