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.
can I transform this process in job?
Moderators: chulett, rschirm, roy
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
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
-
- Premium Member
- Posts: 28
- Joined: Tue Jul 01, 2008 9:23 am
Re: can I transform this process in job?
Reply :qutesanju wrote: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.
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.