We can use Date Conversion function to find out the Year and use SUBSTR fu

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

Question Posted / abhinaw prakash

Answer Posted / abhinaw prakash

We can use Date Conversion function to find out the Year and
use SUBSTR function to extract that particular year.

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is joiner transformation?

1010

Explain the mapping variable usage example in informatica

1165

What is rank index in rank transformation?

1080

Explain the scenario which compels informatica server to reject files?

1168

What is the need for an etl tool?

1068

Please let me know how to make Data masking in informatica..

1726

What is workflow? What are the components of workflow manager?

1177

Separate from an archive server and a powerhouse?

964

What are the measure objects?

1202

What is the sql query overwrite in source qualifier in informatica

1090

How to load the data from a flat file into the target where the source flat file name changes daily?

1062

How can we remove the duplicates from flat file source?

1040

How can we improve session performance in aggregator transformation?

1117

What does role playing dimension mean?

1044

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2038