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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2186


Reusable transformation and shortcut differences

1880


What is the difference between informatica 7.0 and 8.0?

1050


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1645


What are the different transaction levels available in transaction control transformation?

1272


Explain about cumulative Sum or moving sum?

1091


On which transformations you created partitions in your project?

1432


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1119


can you please explain me pre session and post session options?

7670


How to convert multiple rows to single row (multiple columns) in informatica

1425


Can we create multiple integration service on single repository?

1240


Do you find any difficulty while working with flat files as source and target?

1146


Can u generate reports in Informatica?

1143


What is dynamic cache?

1085


What is the Process to creating lookup transformation in informatica

1090