Design a mapping to get year of join for each employee.

Question Posted / ashok

4 Answers
8081 Views
Accenture, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Design a mapping to get year of join for each employee...

Answer / abdul

can we use GET_DATE_PART Function?

Is This Answer Correct ?

7 Yes

0 No

Design a mapping to get year of join for each employee...

Answer / abhinaw prakash

We can use Date Conversion function to find out the Year and
use SUBSTR function to extract that particular year.

Is This Answer Correct ?

2 Yes

0 No

Design a mapping to get year of join for each employee...

Answer / ram

use TO_DECIMAL(TO_CHAR(COLUM,'YYYY'))

Is This Answer Correct ?

3 Yes

1 No

Design a mapping to get year of join for each employee...

Answer / ganesh reddy

use expression t/r in exp write to_char(hiredate,'yyyy')

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Informatica Interview Questions

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers TCS,

what is the difference between onsite & client site?

1 Answers

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers

What can we do to improve the performance of informatica aggregator transformation?

0 Answers

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers

I have source like this 1:2;3. so i want to load the target as 123

4 Answers HP,

What is a unit Testing?

1 Answers

Describe data concatenation?

0 Answers

what is data driven?