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

Question Posted / ashok

4 Answers
9661 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

in which situations do u go for snowflake schema ?

2 Answers TCS,

Different types of Power center errors?

1 Answers Cinterco, IBM,

How does a sorter cache works?

0 Answers

I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers TCS,

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers Polaris,

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers IBM,

What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 Answers

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

3 Answers Cognizant,

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

0 Answers CTS,

surrogate keys usage in Oracle and Informatica?

5 Answers ITC Infotech, Oracle,

What is sequence generator transformation in informatica?

0 Answers

For more Informatica Interview Questions Click Here