DSXchange

Thanks so much Roy!

Hello All:

Can you help me with a best practice to run a dependent job based on condition (e.g. record count in a particular table <= 200,000)? If the record count is > 200,000, then the job should not be run.

Thanks,
T.Vijay

Don't get too much frustrated kenneth. The version of datastage is 6.0. The datastage server is in HP-UX 11i. The database is Oracle 9i which too lives in HP-UX. What other info do you need?

-T.Vijay

Hello Ray:
I know the total number of records in the source sequential file. After loading all the records into target relational DB table, still the status remains "running".

Thanks,
T.Vijay

Hello:
The ETL job even after completion shows the status as "running" (in Datastage director client tool) instead of "finished" status? What is the reason for this?

Thanks in advance,
T.Vijay

Hello Ray:
I am planning to use a bunch of hash files for lookup of very large tables. So, I am just gathering the pros and cons of using them. Because one of our clients had bad experience in using the corrupted hash files.

Smile forever,
T.Vijay

Hello Folks: If the hash file gets corrupted(partially or fully), will there be any error whenever we use that particualr hash file in an ETL job or we need to find it out after loading the junk data into the target stage? BTW, thanks Rasi and Ray for your scintillating(as usual) replies. Smile fore...

Hello folks:
Is there any chance that hash file gets corrupted(hope OS ain't the source of corruption)?
What are the best practices to handle a hash file? What is the limitation in the size of the hash file in datastage 6.0?

Smile[:)] forever,
T.Vijay

You can create a datastage ETL job and write the results to a target sequential file.

Hope this helps,
T.Vijay

Hello folks: I have an output file from an program which contains the following information. update table1 set col1 = 10 where col3='ID'; update table2 set col5 = 10 where col23='ID'; delete from table1 where col3='ID'; insert into table3 values(......); ......................; ........................