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 a router transformation?

620


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

585


How you know when to use a static cache and dynamic cache in lookup transformation?

1331


What is mapplet in informatica?

588


how we can load rejected record's at run time?(not through bad files)

1905






How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

707


What is resilience time?

651


Could you explain what is enterprise data warehouse?

549


Scheduling properties,whats the default (sequential)

1456


What are the types of data warehouses?

936


Explain about Informatica server process that how it works relates to mapping variables?

618


what is the size of u r source(like file or table)?

1810


Please let me know how to make encryption and decryption with example?

1456


What are the types of presistent cache in look up tr.

1541


How can we use mapping variables in informatica?

595