I have table name called Team and I have name and DOJ in that table in oracle,

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

3 Answers
8377 Views
CSC, I also Faced
E-Mail Answers

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

What are the different types of transformation available in informatica.

0 Answers

Is it possible to define a single node as a Gateway node as well as worker node?

0 Answers

wf dont have integration severances how you can run?

0 Answers TCS,

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 Answers Zensar,

my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica

3 Answers HP,

Explain where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

0 Answers

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers TCS,

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers

What is a test load?

1 Answers

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers TCS,

How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers Informatica,

For more Informatica Interview Questions Click Here