can I transform this process in job?

[qutesanju]

Hi all

I have one procedure in backend which is process data like

select data from physical table
insert into temp table
do some verification and calculation
and insert into second temp table
then select * from second temp table

I need to find alternate way for procedure in datastage as i m not getting which components whould i use in ETL for above procedure.

[chulett]

Three DB stages chained together by transformers is most of it. You'd need to explain what to do with the last "select *" information, though.

[mk_ds09]

select data from physical table
insert into temp table
do some verification and calculation
and insert into second temp table
then select * from second temp table

What you can do is like the following :-

1. Database stage to read form the physical table.
2.Here you dont have to use the temp table.
3.Use the transformer for verification and validation.
4. No need of temp table again
5. Write to the file..

If you want to select something ..you can use this file to select.

Now it depeneds on how you want to select from your outout..
depends on the use of your output..!

----------------------

Hope this helps

--------------

MK

[gxhpainter]

Hi all

I have one procedure in backend which is process data like

select data from physical table
insert into temp table
do some verification and calculation
and insert into second temp table
then select * from second temp table

I need to find alternate way for procedure in datastage as i m not getting which components whould i use in ETL for above procedure.

Reply :
Option 1 : You can use sequence of Jobs , first you write to 2 temp tables and second job will read the second table

Option 2 : You can use commit row value to 1 in DB stage and we can accomplish in single job.

Chakradhar.