1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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,

Question Posted / rajeshreshi

Answers were Sorted based on User's Feedback



I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the ..

Answer / bk

TO_CHAR(DOJ_port, 'MMDDYYYY')

Is This Answer Correct ?    14 Yes 0 No

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the ..

Answer / yashvi

You can use TRUNC function in exp transformation e.g
TRUNC(to_date(fieldname,'mmddyyyy')

Is This Answer Correct ?    6 Yes 0 No

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the ..

Answer / srinu

oracle support range
Jan 1, 1753 AD
to
Dec 31, 9999 AD

in informatica
The default date display format is
DY MON DD HH 24:MI:SS YYYY.
When you specify a date display format,
it displays in the test window. An invalid date display
format is marked invalid.

if u not able to Understand,,,,

Please send the Question Clearly,,,,srinu

Is This Answer Correct ?    3 Yes 7 No

Post New Answer

More Informatica Interview Questions

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,

What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

5 Answers   Cap Gemini,

how to get flatfile containg 10 records half records one target another half another target

2 Answers  




without using emailtask how will send a mail from informatica?

3 Answers  

what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,

What is IQD file?

1 Answers  

what is lookupoverriding?

1 Answers  

In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?

4 Answers  

The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers   Cap Gemini,

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

For more Informatica Interview Questions Click Here
Categories