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
- 8354 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
How to use pmcmd utility command?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How to load a Dimension ? and how to load a fact table?
Explain the difference between mapping parameter and mapping variable?
Explain the etl program with few examples.
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the data movement modes in informatica?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
differences between service based and product based?
What is the difference between stop and abort in informatica
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
How can you generate reports in informatica?
What is a difference between complete, stop and abort?
