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
What are the reusable transformations?
Explain the different lookup methods used in informatica?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is substr in informatica?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
When do you use sql override in a lookup transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How to create a non-reusable instance of reusable transformations?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are the settings that you use to configure the joiner transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How to use procedural logic inside infromatica?
What is dynamic cache?
How do you take back up of repository?
What is the use of source qualifier?