DSXchange

What i have done is used the lookup stage , to get the max value from the database . lookup key should always be true (create a dummy column for that). Also we can run the lookup stage in sequential mode,since thatis what we want . In the next stage you can add this to a (sequence number generated u...

since heap memory allocation is from physical memory , try to increase available physical memory . can you try using lookup stage
in place of join stage

Also try this option . Define the Job parameters in a sequencer job and set those to the parameters in the job activity. This way it will be easier to maintain.

Try connecting to oracle using toad or sqlplus .If you have problems verify whether entries tnsnames.ora are correct .I dont think this is Dstage problem .

Hi ,

CAn you try this option , i think if the incoming value has null then you cannot specify (ip_column2)[1,7]

if i/p_column1 = "A" then
IF IsNotNull(ip_column2) THEN
ip_column2[1,7]
ELSE
SetNull()
Else SetNull()

I think you should try setting the lookup condition , to make sure you do not lookup for amounts which is in USD . Also if you write a if statement try setting @TRUE or @FALSE based on evaluation of the condition

I now resolved the problem by removing the link and attaching the link back again with input link first to be attached to lookup stage and then the reference link. I thought Datastage is smart to handle that,but does not work that way

I use Oracle enterprise stage , and it works for some which has a reference link , i have checked the keys for the lookup in all the cases
??

Hi , I have a job which has 6 lookup stages , But in some of the lookup stages the input columns option is disabled . Since this is required for setting the lookup condition , any clue what i am missing out here?