AnsweredAssumed Answered

Control Functions and sequence of tables during publish

Question asked by satish.kumar.enni on Dec 8, 2016
Latest reply on Dec 27, 2016 by satish.kumar.enni

Hi,

 

I have two issues

 

1. I have two tables one is employee and other is salary table as below 

 

Employee table

empno    empname  salary

1001        satish         500

1002        kumar         200

1003        enni            100

1004        Ishanth       500

1005        Yashdeep   100

1006        Yuvaraj       500

Salary table                  Out put to be 

empno                           empno    

                                        1001        

                                        1004        

                                        1006       

 

So from above, i have to fill salary table with empno from employee table whereever salary =500.

 

2. Is there any way to change the sequence of tables during publish to target, because one of my tables should go in a sequence.

 

Please anyone help me on my queries.

 

Thanks in advance

 

 

Regards,

Satish

Outcomes