Informatica Scenario Load Alternate Records to Targets:Best Approaches

The Video Demonstrates 2 different appraoches how we can Load Alternate Records to Targets using Informatica
The approaches are
1.Using SQl Override 2.In case of a flat file
The Key Learning's from the video apart from the scenario are
1.Analytical Function Row_number()
2.Case in Oracle
3.Filter Transformation
4. Router Transformation
The Video in its second half takes a next step and explains how we can load alternate records in different targets using the 2 apporaches
#Informaticapowercenter #InformaticaTutorials #TechCoach

[namdevgaribe]

Such a Nice explaination..very helpful

[vaishanvimondhe]

Hi sir can you tell me.... how to generate department wise rank using expression transformation in informatica and one more thing source and target both are flat file And plz sir reply me as soon as possible

[kamaljoshi]

Very nice way of explaination.. Thanks for sharing and helping in learning

[bratisankarchakraborty]

Can we use empid%2=0 for even record and empid%2=1 for odd in expression then use router?

[pratimab]

we can use SQL query like select e.*, mod(empno, 2) as flag from employees e. instead of the case statement right?

[maryam]

in the second approach, we don't need to sort the result based on the employee id?

[abhisekmohanty]

Can't we use ROWNUM Pseudo columns instead of Row_Number ( ) ?

[ameysa]

How can I load first record in first table, second record in second table, third record in third table, fourth record in first table and so on