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...

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

Answer Posted / ganesh reddy

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the mapping parameters and mapping variables?

1084


What do you mean by blocking transformation?

969


What is parallel processing in informatica?

1616


can anyone suggest best free Talend data integration training online

1622


What does command task mean?

1060


What is informatica?

1075


Differentiate between router and filter transformation?

951


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7113


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

2349


According to his methodology what all you need before you build a datawarehouse

1689


expain about the tune parameters?

2336


What is a predefined event?

1029


What is an expression transformation in informatica?

962


How to create the source and target database connections in server manager?

1033


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1216