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 the difference between Active and Passive transformation?

1150


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2356


What is depict expression change?

1116


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2104


What are the different components of powercenter?

1053


How we can create indexes after completing the load process?

1158


Explain in detail scd type 2 through mapping.

1039


Separate from an archive server and a powerhouse?

961


What is xml source qualifier transformation in informatica?

1217


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1904


What is domain and gateway node?

1165


Slowly changing dimensions, types and where will you use them

1713


Explain sessions and how many types of sessions are there?

1006


What are the static cache and dynamic cache in informatica?

1189


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

1054