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,
- 3 Answers
- 7090 Views
- CSC, I also Faced
- E-Mail Answers
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
What is a repository? And how to add it in an informatica client?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
what is song in infrmatica...?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is native users?
What is a connected transformation?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain the tuning lookup transformation - informatica
How can we store previous session logs?
What is sq transformation?
How many input parameters can exist in an unconnected lookup?
how we can load rejected record's at run time?(not through bad files)
What is a transaction control transformation?
