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
- 8156 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 are the advantages of informatica?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is a router transformation?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is a dimensional model?
What are ETL Tools?
What you know about transaction control transformation?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
lookup transformation with screenshots
Mention few advantages of router transformation over filter transformation.
How you can differentiate between connected lookup and unconnected lookup?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
