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

use TO_DECIMAL(TO_CHAR(COLUM,'YYYY'))

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is informatica? Why do we need it?

1041


Can we change Dynamic to Static or Persistent cache? If so what happens?

2152


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2102


What's the layout of parameter file (what does a parameter file contain?)?

2337


What are the components of Informatica? And what is the purpose of each?

983


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1076


How can we store previous session logs?

992


Explain sessions. Explain how batches are used to combine executions?

954


What is rank transform?

944


What is the function of union transformation?

1067


How do you handle two sessions in Informatica

1076


Explain how many types of dimensions are available in informatica?

1010


What is the need for an etl tool?

1013


What is meant by active and passive transformation?

1031


Different qualification between a related rotate toward the sky and isolates look upward?

931