DSXchange

Hi All Is there any reason why having multiple input streams to a single ORAOCI8 stage would cause performance problems? For some reason the job will be running along nicely until it reaches about 10000 records then the rows/sec drops off severely. To the point where I am at this point having to spl...

I think a transformer stage cannot get reference input from sequential file I'm pretty sure Suresh is saying to use the sequential files in the merge stage, not as a referential link to a transformer. The merge stage does not have any input links per se. You specify the two sequential files you wis...

There is nothing wrong in going with separate insert and update but wouldnt that increase one more job. That is on one job I will do update where as in other job insert. Is it possible to have two links in one job...one which updates the database whereas other which inserts. I think thats nlt possi...

Not sure of its datastage context, but usually it is some sort of Purchasing Card. Like a credit card, but linked to debit account.

Captain of the USS Enterprise? :D

Sorry couldn't resist

Not sure this would work but, you could incorporate Ray's idea of using Stage Variables to check the validity of the incoming data. If the particular field is invalid is someway have the output be a warning message for that field eg stagevar1 = If input.field1 valid then '' else 'Error Code|Error Me...

If the number of columns that you are receiving is variable and you have to get the last column you could try an amalgamation of a couple of functions. Read the input row in as one field, and use an amalgamation of the Field and Count functions eg: Field(input.string,'|',(Count(input.string,'|')+1),...

But how are limiting the output? Each time in your examples, you are only showing one output but you have said that its possible the constricting value could be 'source' or 'select' or many others. How are you determining which value the output is to be restricted by? Ie Are you only ever wanting o...

Ray, Let me explain what I am trying to achive. 1. I have two sources. 2. I am trying to process these records in to a single target table (TERADATA) through one datastage job 3. I am trying to merge these records and push them into the target table 4. There might be a case when the two sources can...

But how are limiting the output? Each time in your examples, you are only showing one output but you have said that its possible the constricting value could be 'source' or 'select' or many others. How are you determining which value the output is to be restricted by? Ie Are you only ever wanting on...

bapajju wrote:
Is there any other way to replace link collector?

Thanks in Advance

You could just write them to sequential files and concatenate them in UNIX.

And besides, surely you don't need all the columns to be keys to make a record unique - I think that is what Ray was alluding to.

[quote="prasad111 ... my conclusion will be that it is not possible to implement the above question using only one HASH FILE, [/quote] It can be done with one hash file - but you would just have to refer to that one hash file 30 times. :) However - i am just wondering if I understand what you a...

Is the value of table2.col3 literally 'Source'? If so select the values from that table into a hash file with two columns. Use a query like select col4, col5 from table2 where col 3 = 'source' On the hash file set the first column (col4) as the key. Link this column to your input table. If hashlooku...

Can you use a stage variable to do a replace on the incoming row? Basically check to see if the incoming column is "ALL". If so replace the row with a concatenation of the 3 required rows separated by a line seperator. ie variable output would be something like ColA:'|':ColB:'|X|':ColC:Cha...

Hi Everybody Has anyone ever encountered this error before? A search of the forum revealed one other posting but it was in the parallel forum and for a different server. Basically we are doing an insert into Oracle using a ORAOCI8 stage using an Insert Statement. If the insert is rejected then it pa...