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 / bk
TO_CHAR(DOJ_port, 'MMDDYYYY')
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How do you remove duplicate records in informatica? And how many ways are there to do it?
explan ur project architecture?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is the need of an ETL tool?
State the differences between sql override and lookup override?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What are the advantages of informatica?
How do you load unique records into one target table and duplicate records into a different target table?
How to call shell scripts from informatica?
How can one identify whether mapping is correct or not without connecting session?
r u done any partitions in ur project?
What is DR strategy for Informatica project?
What is deployment group?
What is the surrogate key?