Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8375 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 decode in informatica?
What is meant by target load plan?
What are the different types of transformation available in informatica.
In warehouses how many schemas are there?
Explain target update override in informatica
Differentiate between reusable transformation and mapplet.
what is size of u r database?
How can we use mapping variables in informatica?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Explain lookup transformation is active in informatica
explain one complex mapping with logic? sales project?
What is a joiner transformation and why it is an active one?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
