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

How do you manage the Parameter files while migrating your data from one environment to another environment?

1033


What is exclusive and normal mode for repository services?

1149


Explain the code page compatibility?

1074


server hot-ws270 is connect to Repository B. What does it mean?

2569


Could you explain what is enterprise data warehouse?

1150


Explain the types of transformations?

1073


What is pmcmd command?

1129


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

1093


What are the transformations that are not supported in mapplet?

1033


How many transformations can be used in mapplets.

1940


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6498


Under what conditions selecting sorted input in aggregator will still not boost session performance?

1082


COM components can be used in Informatica

2397


Explain lookup transformation source types in informatica

1104


what are the Methods For Creating Reusable Transformations?

1183