Karthik
Load one table into DataStage and let it generate the SQL. Change it to user defined SQL and add the union.
Kim.
Kim Duke
DsWebMon - Monitor DataStage over the web
www.Duke-Consulting.com
Union in Datastage Designer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 56
- Joined: Thu Feb 13, 2003 6:08 pm
- Location: USA
Karthik
You still have a couple choices. You can create a dblink in Oracle so that the UNION works in Oracle. You can select one table post it. Select the next table and post it. Post it to a temp table or a hash file. Use this as your source.
Kim.
Kim Duke
DsWebMon - Monitor DataStage over the web
www.Duke-Consulting.com
You still have a couple choices. You can create a dblink in Oracle so that the UNION works in Oracle. You can select one table post it. Select the next table and post it. Post it to a temp table or a hash file. Use this as your source.
Kim.
Kim Duke
DsWebMon - Monitor DataStage over the web
www.Duke-Consulting.com
Hi,
it is possible to load the data without user defined query but with 2 jobs (simpler to implement but difficult to manage) or 1 job (more difficult to implement but easier to manage )
first solution
job 1 -> load the data from remote host (table A) to local table in your host. You must set "truncate table then insert" upodate action
job 2 -> load the data from remote host (table B) to local table in your host. You must set "insert without clearing" upodate action
the problem is that you must run job 1 and AFTER job 2
second solution
job -> it is simplier to design the job (ignore the ".")
.......................................(2)
....................B--------> T -----> LOC_TAB
...................................^
...................................| (3)
........................(1).......|
..........A ---> T ----> LOC_TAB
where
A fisrt remote table
B second remote table
T trasformer
LOC_TAB local table in you host
(1) update action "Truncate table"
(2) update aciotion "insert without clearing"
(3) a query like "select sysdate from dual". It is necessery because the load of data from table B must be after the load from table A
and this link do it
Mario
it is possible to load the data without user defined query but with 2 jobs (simpler to implement but difficult to manage) or 1 job (more difficult to implement but easier to manage )
first solution
job 1 -> load the data from remote host (table A) to local table in your host. You must set "truncate table then insert" upodate action
job 2 -> load the data from remote host (table B) to local table in your host. You must set "insert without clearing" upodate action
the problem is that you must run job 1 and AFTER job 2
second solution
job -> it is simplier to design the job (ignore the ".")
.......................................(2)
....................B--------> T -----> LOC_TAB
...................................^
...................................| (3)
........................(1).......|
..........A ---> T ----> LOC_TAB
where
A fisrt remote table
B second remote table
T trasformer
LOC_TAB local table in you host
(1) update action "Truncate table"
(2) update aciotion "insert without clearing"
(3) a query like "select sysdate from dual". It is necessery because the load of data from table B must be after the load from table A
and this link do it
Mario
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Job Type
![Exclamation :!:](./images/smilies/icon_exclaim.gif)
This confusion is one of the reasons those new fields appear at the top when you post a new message. If the OP had signalled that server jobs were implied in the question, an answer pertinent to parallel jobs would have been less likely to have been given.