Informatica - How to remove duplicate records using Expression

Informatica - How to remove duplicate records using Expression

Read the blog and understand the logic before watching this video.

Please do LIKE and SUBSCRIBE the channel for more videos!

LIKE & Follow my Facebook page for more related topics!

Visit my website for detailed documentation!

[cassondrad]

Excellent job. You documented in detailed each step that needed to be taken not only in word doc but also each step that you took to accomplish this task. Very well done and I enjoyed the music you provided, I didn't mind you not adding your voice. Some add their voice but if it's not English, I have an issue in trying to make out what they are saying so it does me no good. Awesome Job, well done, Kudos

[campcloud]

Thanks for the video, just pointing out to others the key concept here is the order of the ports (also called fields in Informatica Cloud). At first I had the ports/fields in the incorrect order and it wasn't working. The last port has to be V_PREV_JOB_ID because it's going to reset each time a new row is evaluated, and if it calculates before V_COUNTER it's going to give incorrect results. Again thank you for the video, saved me a bunch of time!

[sudheerk]

thanks bro.. i have been asked this question in interview i said all the possibile options like distinct, groupby etc.., but he is very particular using EXP.. it helped me a lot :) also one suggestion before you are running workflow better to show the duplicate data.

[manojrnmishra]

Good job, Please add voice to make it more appealing.

[subhaselvi]

Good job!! please remove this music and add your voice