You can use TRUNC function in exp transformation e.g TRUNC(to

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,

Question Posted / yashvi

3 Answers
8374 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

Please Help Members By Posting Answers For Below Questions

What are the types of data warehouses?

1534

What is substr in informatica?

1219

Explain constraint based loading in informatica

1104

What does command task mean?

1160

Design a mapping to load a target table with the following values from the above source?

1357

what is unit testing?tell me proceedure

2236

How to do unit testing in informatica?

1189

4 yrs etl devloper roles and responsibilities?any body give solutions

2178

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8231

Name the different lookup cache(s)?

1240

Different circumstance which drives informatica server to expel records?

993

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6196

What is dimensional table? Explain the different dimensions.

1178

Quickly characterize reusable change?

1131

hi real timers . iam waiting for ur reply regarding ETL TESTING

2282