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
- 8151 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
What is a filter transformation?
Explain your project of banking domian.
How to generate sequence numbers without using the sequence generator transformation?
What do you understand by term role-playing dimension?
Separate from an archive server and a powerhouse?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Explain the different lookup methods used in informatica?
Explain scd type 3 through mapping.
How can we use mapping variables in informatica? Where do we use them?
difference between repository database and repository service?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is a sequence generator transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
How identifying bottlenecks in various components of informatica and resolving them?
What is a transaction control transformation?
