Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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

Question Posted / ashok

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

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

0 Answers  

What is Factless fact table ???

12 Answers   Satyam, Tech Mahindra,

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

0 Answers   Cap Gemini,

What is joiner cache?

2 Answers   TCS,

How to load a Dimension ? and how to load a fact table?

0 Answers  

How do you change parameter when you move it from development to production.

1 Answers  

one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,

What is the format of informatica objects in a repository?

0 Answers  

What is meta data and system catalog?

2 Answers  

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

0 Answers  

how to insert header after each group.

1 Answers   IBM,

What are the different types of Type2 dimension maping?

1 Answers  

For more Informatica Interview Questions Click Here
Categories