Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Question from stacyhobbs321 on Sep 9 at 3:59 PM I have a requirement here. I have 6 input tables. Say T1....T6.
Now on every execution of the job not every table will be available. I am reading those tables using query component( like select * from T1 etc).
On execution 1 may be only T3, T4, T6 is present.
On execution 2 may be only T1,T2,T3, T4,T5 is present
On execution 3 all tables may be present.
I am joining all 6 tables and creating 1 single file. How can I make these querty components conditional? Say If T3 is not present or any table is not present my job should not fail and should read from other 5 tables. Can anyone help, please?
| Reply to this email to post your response. __.____._ |   _.____.__ |
