DSXchange

hi i am collecting all records in reject file , i wann to include the reason for each row that is getting reject, here i have added one more column in reject file as REASON, nw i wann the message which comes in the director for rejected row to see in this column , is there any way to do this

thanks for solution

here if i wann that all jobs should run in any condition , i.e. if the if 1st job run successfully then also i wann that all job should run . i have tried ur should yet but is it possible with ur soln

yes i wann it in this way only , u got it right

thanks for the quick reply, that job property is alredy unchecked hi , here i will explain problem in detail, all four jobs in seq1 and seq2 are running one after the other with trigger condition UNCONDITIONAL. so if first of four jobs aborts then only i wann that my seq1 and seq2 and mainseq should...

hi In my sequence(main seq) , there are two sequences(seq1 , seq2) and each of these seq is having four jobs running. I want this main seq to run , even if any of these eight jobs or any seq1 or seq2 is getting aborted . Even my mainseq show abort status ,its ok, but all the jobs other than jobs get...

Hello Ray,
That means I have to design two similar job. Then execute the first one & finally execute the second one.

How can I preexecute the select statement in Data Stage Job? I have executed the query in TOAD & getting the result.

Hi, I am loading data to a table from a view which contains 13 lacs record. It took 13 hours to load the table. My design is very simple. Source View----> Transformer------> Target table Can you please let me help in increasing performance? The loading option for target is "clear the table then...

Thanks a lot to all of you for your suggestion. The job is working fine now. We have allocated more space to tablespace, restarted the database & used partitioned table.
Thanks again

Hello Kumar,
I am not able to view data by command line prompt also. There also I am getting the same error. Should I remove the index & then try?

Can you please advise some tuning tips? I have already created index on the table on which view is created. Thanks.

Hi, I am facing problem while extracting data from a view to a table through ETL. The view contains huge amount of data. The error which i am getting is "unable to extend temp segment by 128 in tablespace TEMP2". I have reported the same to DBA here & he had increased the memory of tab...

Hi

the exact error is as

'JOB_CDW_FACT_PEX_TD..TRANSIT_DTLS_H.IDENT9: |JOB_CDW_FACT_PEX_TD..TRANSIT_DTLS_H.LINK_TRANSIT_DTLS_H: DSD.UVOpen Unable to open file 'C:\AFL\HASH_FILE\LINK_TRANSIT_DTLS'.|'

hi i have one job which was running previously , but nw its not able to open the same hash files which are there. and also i tried with renaming the hash files still same error the job is getting aborted , when i tried to delete these hash files from server it gives messages as sharing voilation and...

I am getting this error
Job Aborted after 50 errors logged. and have no idea about it. plz anyone can help me