DSXchange

Am I looking at the correct variable?

APT_DUMP_SCORE=1

Thanks,

Still getting same error.

YEs ArndW, I am calculating total sum in aggregator stage and then I am using sort stage, transformer and then a join and finally loading in to a oracle table. I am capturing key change in sort stage and after transfromer stage I dropped those key_change columns. Apart from that I am using everythin...

No warnings at all. It's throwing error directly.

ray.wurlod wrote:Easiest is an Execute Command activity in a sequence to initiate a sqlplus command (script). ...

Thanks Ray.

crystal_pup wrote:If your source and target is Oracle, then you can create a job that reads a dummy row from a Row Generator Stage and feeds it to an Oracle Connector Stage. In the Oracle Connector Stage, you can write a INSERT INTO...SELECT ...FROM query.

Thanks Sura.

Hi, I am getting error on aggregator stage " Aggregator_43: Error when checking operator: Could not find input field ". The job was running fine until 3 days before suddenly it started throwing error when I tried to run today. I checked input columns and data everything seems fine and stil...

SURA wrote:If you are doing any transformation, then write the output in to a text file and find any way to load that file using bulk load command.

I did the same approach in SQL Server.

Do you mean first write the entire data to a text file and then load into the oracle table ?

Thank you,

If this is Oracle to Oracle you may find that doing the whole thing within Oracle using Oracle utilities is faster. You may still choose to initiate/control that from DataStage. If you prefer to ... Hi Ray, Could you please guide me in that direction, how can I initiate/control from DataStage? Than...

Thanks Chulett.

Yes Chulett,
It contains records with all years. On Target side can I use bulk load and before sql statement or Delete and then insert ? Whats the difference between these two?

Thank you,

Hi, Please suggest me a best way. First run: Source: 30 million rows Target : 30 million rows After first run from second time on wards I have to delete 2013 records on target and insert 2013 records. I designed job like Oracle connector -----> Oracle connector Source side: select * from ***** where...

Hi,
I am using bulk load option in oracle connector on target side and enable partition on source side. I am getting around 30 million records on source side. I just curious to know is there any better way to do transfer in efficient way.

Thank you,

I am using sort stage and then remove duplicate stage to implement above logic. Is there any better way to get this done? Suggestion please.

If you want to pursue the first method, show us the syntax you used and we'll go from there. ... Stage: DSLink2.KEY:'01' --- DATE (varchar) StringToDecimal(DATE) --- Output (decimal) Output: Output --- Date_output (decimal) But I am getting output same as input. So, I modified logic like this Stage...