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
- 8217 Views
- CSC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yashvi
You can use TRUNC function in exp transformation e.g
TRUNC(to_date(fieldname,'mmddyyyy')
| Is This Answer Correct ? | 6 Yes | 0 No |
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 |
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav
Explain the use of aggregator cache file?
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
explain different levels in pushdown optimization with example?
What is power center repository?
What are steps to follow Informatica migration from 7x to 8x? Pls Explain...
What is Code Page Compatibility?
How do you implement scheduling in Informatica?
Clarify the utilization of aggregator cache record?
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
What is Cognos script editor?
Teradata 
