DSXchange

You could also create a file with Datastage in a required format and load it using LSMW. This of course means not using the plug-ins.

Also SAP is a very large ERP. If you after general answers then you will probably not get the answers that you want. But in an attempt to answer them briefly 1) If we load data from any legacy systems(Mainframe, db2) what are the best available load options (IDOC,ABAP,BAPI). The thing is each option...

Firstly you are probably in the wrong forum. This forum is for Datastage not SAP. Datastage is just one of many tools that one can use to prepare data for loading and load data to SAP.

You might want to try SDN forum here

karry450 wrote: No that wont give me my requiremnt.

anyother way please.

Can I ask why that won't give you your requirement. I would think that some sort of inner join in SQL would be quicker?

Are all 19 fields key fields in each table?

Can you do a user defined SQL and do the join in your query to give the required output?

i tried which u suggestesd above and i finally got the result. thanks alot for posting this result and quick response. still i have doubt about below but earlier when i test with the reverse order of your stage variables order i got below result . ... could any one Please clarify me how could we fo...

That definitely sounds like a bug. Have you reported it through your support provider? Clearly you can generate a reproducible case. When you say "SQL Server stage" I presume you mean "SQL Server Enterprise stage"? Are you selecting from the same table that you are updating? Hi ...

DS_SUPPORT wrote:make sure, the input data is sorted , before applying the above said logic.

Good Point!

What's your reason for wanting to move away from having rejects go down the reject link? What have you got against the reject link? You're using the right solution for your requirement - don't feel bad that it's got a negative-sounding name :-) I think any alternative solution is likely to involve ...

Thanks for reply. Actually at present I am using the reject link as the throughput, and the output link actually contains the "rejects" (ie the ones that found a match in the file set). I was just wondering if there was a way of performing the task without having the throughput on the reje...

Investigate the use of stage variables.

Basically you want to set up 3 variables, one that holds the value of the previous record, on that compares variable one to the current record and another that acts as a counter depending on whether there is a match or not.

I have a simple job (sql -> lookup -> transform -> sql) which was working fine with a sequential file as the target but when I change the target to a SQL server stage it falls in a heap. The transformer in question maps the source columns to the target columns (ie the column names are completely dif...

Hi Everybody I am wondering if its possible to use a lookup fileset to exclude records from a source? My job runs as such: Source: SQL Server Stage Lookup Stage which references a lookup file set containing 3 columns all of which form the key. If a match is found on all 3 columns then I would like t...

So you are only requiring the last bit of the field past the _? Ie the _xxxx will always be at the end? If so the easiest way would be to treat the underscore as a delimiter. Perform a count of how many underscores there are in the field then use that number in the Field function to extract the last...

How many records in the lookup? Not that it should really matter - I can't see how a hash file could take that long - an oracle table lookup could take a while if you lookup was based on non key fields and you were doing full table scans, but a hash file should not have that problem. Are you getting...