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
- 8342 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
Briefly explain the aggregator transformation?
How do you migrate data from one environment to another?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How many input parameters can exist in an unconnected lookup?
What is data transformation manager process?
What do you mean by channel change?
Explain direct and indirect flat file loading (source file type) - informatica
What is the Process to creating lookup transformation in informatica
What all join we can perform in LOOKUP transformation?
What is the way to execute pl/sql script using informatica mapping?
Explain in detail scd type 2 through mapping.
Explain the difference between mapping parameter and mapping variable?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is union transformation in informatica?
How do you set a varible in incremental aggregation
