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

tell me about your project functionality

1870


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1760


What is InformaticaPowerCenter?

694


How to elaborate tracing level?

689


How can we improve session performance in aggregator transformation?

678






is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

633


What are the designer tools for creating transformations?

687


How to start a workflow using pmcmd command?

715


How do you load unique records into one target table and duplicate records into a different target table?

713


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

607


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1741


Can u generate reports in Informatica?

661


What is a surrogate key?

563


What is a sequence generator transformation?

580


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1912