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,

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

what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,


HOW DO YOU CONNECT TO REMOTE SERVER ?

1 Answers   Patni, TCS,


After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  


Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  


i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers  






What is lookup change?

0 Answers  


What is the command used to run a batch?

0 Answers  


Write the prerequisite tasks to achieve the session partition?

0 Answers  


wat s mapping parameter and mapping variable? how do you set that in a mapping?

3 Answers  


 Informatica Checkpoints

0 Answers   DELL,


Explain how to import oracle sequence into informatica?

0 Answers  


How to implement security measures using repository manager?

0 Answers  


Categories