I could run the insert job twice, pulling in different column at a time.
But I was wondering if i could do this in one job or if there was a better approach to this?
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
SELECT A FROM tablename UNION ALL SELECT B FROM tablename;
Naturally this requires that columns A and B have compatible data types but, then, so does inserting them into the one column in your target. If they are incompatible, use CAST to guarantee that they are in the result of the query.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
You could also use a funnel stage. Use a copy stage to send the table data into 2 streams.
Col A would be renamed to Col C in one stream and Col B would be renamed to Col C in other stream. You can funnel them and take Col C as Col A and col B data together.
Yes and no. There isn't a collection method in the Link Collector stage that permits "all from source A then all from source B". The (parallel) Funnel stage has a "Sequence" method that permits this mode of operation.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod wrote:Yes and no. There isn't a collection method in the Link Collector stage that permits "all from source A then all from source B". The (parallel) Funnel stage has a "Sequence" method that permits this ...
Ooops! Misread the requirement. Will work on that. Thanks