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
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 |
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 |
what is the purpose of surrogate key and diff between primary key&surrogate key
HOW DO YOU CONNECT TO REMOTE SERVER ?
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
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
What is lookup change?
What is the command used to run a batch?
Write the prerequisite tasks to achieve the session partition?
wat s mapping parameter and mapping variable? how do you set that in a mapping?
 Informatica Checkpoints
Explain how to import oracle sequence into informatica?
How to implement security measures using repository manager?