This content has been marked as final. Show 2 replies
JoeSSI wrote:Where from the 2nd row is coming into target table ? What is the logic for it ?
Source Table A:
row_id start_date end_date
1 1-jan-2012 3-jan-2012
transform to :
Dest Table B:
How is your row_id is increasing in target table ?What is the logic for it ?
what transformation operators should i use?and how to use it?
I am new on this
Thank so much before
One technique is to union the source with itself;1 person found this helpful
select start_date some_date from src union all select end_date some_date from src;
You can do whatever transformations you want with the other target columns.