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
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
Can we override a native sql query within informatica?
How can we use mapping variables in informatica?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Define update strategy?
Define filter transformation?
How to update a particular record in target with out running whole workflow?
Enlist the tasks for which source qualifier transformation is used.
what is the hint? how to use it to reduce the query processing in program?
what is the size of u r source(like file or table)?
Explain direct and indirect flat file loading (source file type) - informatica
What is the different lookup cache(s)?
How would you join a node to the already existing domain?
What are the differences between source qualifier and joiner transformation?
What is exclusive and normal mode for repository services?