Rank & Window Function
I wanted to create two static fields for two different tabels coming from WB.
1.One is ID- unique # for each row.
2.Source- which differentiate which data belongs to table A and Table B
eg : Union ALL both tabel A & B final o/p shall be :
ID| Product| Class| Source
1 |AAA | C | table A
2 |ABC | D | table A
3 |AAA | C | table A
5 |AAc | CC | table B
I am able to successfully add column ID in both tables A & B. How can I create Source column ?