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,
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
Explain the types of transformations?
Difference between Data and Index Caches?
Write the prerequisite tasks to achieve the session partition?
Explain about cumulative Sum or moving sum?
How to do unit testing in informatica? How to load data in informatica ?
How you can differentiate between connected lookup and unconnected lookup?
How to load the data from a flat file into the target where the source flat file name changes daily?
Explain the use of aggregator cache file?
Enlist the various types of transformations.
What is a dimensional model?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
whats the logic to load the lower level of granularity of data to fact table.
Repository user profiles
What is lookup transformation?