sql scripts
Posted: Fri Sep 24, 2010 5:58 pm
Hi All,
I was assigned a task to convert system generated sql script to datastage job and iam using server edition 7.5 version.
sql script consists of 15 tables and 3 views and and many joins and many subqueries , the sql script is almost 3 pages and it is deleting and inserting records and the first 2 lines of the query is mentioned below.
delete from tablename
insert into tablename followed by query.
so i dint in this way.
oracle----->transformer--------->target
and ihave pasted complete query in custom sql and then mentioned clear the table then insert rows under update action in target table.
Is it a good idea to do like that or is it good to break complete sql and then built the job based on the query?
can any one suggest plz.
I was assigned a task to convert system generated sql script to datastage job and iam using server edition 7.5 version.
sql script consists of 15 tables and 3 views and and many joins and many subqueries , the sql script is almost 3 pages and it is deleting and inserting records and the first 2 lines of the query is mentioned below.
delete from tablename
insert into tablename followed by query.
so i dint in this way.
oracle----->transformer--------->target
and ihave pasted complete query in custom sql and then mentioned clear the table then insert rows under update action in target table.
Is it a good idea to do like that or is it good to break complete sql and then built the job based on the query?
can any one suggest plz.