Friday, 10 May 2019

In my source table 1000 rec's are there. I want to load 501 rec to 1000 rec into my Target table

In my source table 1000 rec's are there. I want to load 501 rec to 1000 rec into my Target table 

Ans:--

Job Desgin:-

Take Source File as Input After Connect Tmap Create Sequence Number and After Tsample Row Select Range 501..1000 the After Target Table....

Tmap:-

T Sample Row:-

 

After ur target Table

 

Thank you...

 

No comments:

Post a Comment

Scinario Based interview Question .....

 How  To Achieve The Scenario. Input File1.csv  id,Name 1,Mahendra File2.csv City, State Hyd,Telangana File3.csv Stateid Ts I want Out put F...