Design a mapping to get year of join for each employee.

Answer Posted / ganesh reddy

use expression t/r in exp write to_char(hiredate,'yyyy')

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an expression transformation in informatica?

524


What is decode in static cache?

598


How do you promote a non-reusable transformation to reusable transformation?

665


What is the use of code page?

612


What is the function of union transformation?

621






what are the deliverables?in your project?

1665


How do you load only null records into target? Explain through mapping flow.

1509


What is the use of source qualifier?

679


How can you define user defied event?

626


Explain pushdown optimization $pushdownconfig parameter - informatica

705


What is an unconnected transformation?

669


Explain what transformation and how many are there in informatica?

494


Why update strategy and union transformations are active? Explain with examples.

716


Mention some types of transformation?

607


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1055