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
- 8470 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / yashvi
You can use TRUNC function in exp transformation e.g
TRUNC(to_date(fieldname,'mmddyyyy')
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Explain the pipeline partition with real time example?
Why sorter is an active transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is a standalone command task?
Describe expression transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Briefly define reusable transformation?
What does reusable transformation mean?
What are the types of lookup transformation?
How can we delete duplicate rows from flat files?
Explain incremental aggregation in informatica
What is the use of target designer?
How are the sources and targets definitions imported in informatica designer?
Implementation methodology
