DSXchange

What is your source and target ???

Since the reference data is too big I am planning to use Sparse look up.. Before that should i have to confirm this by checking the RAM size???
Is it that only when RAM is too small to fit reference data we got to go for Sparse look up...??

Can ODBC stage replace Oracle stage..? Oracle also used ODBC connection.. what s the difference between them?

can any one help me with BAPI.. what do we need this to call sap data..???

I am really very new to ABAP stage.. I dont understand what u mean by build..???
However i see couple of options like BAPI, which is used to pass some parameter to sap..
But in my case source is SAP and target is oracle.. Do i make some sense?

Hi..

Does any one have knowledge using ABAP plug in???

Hi.. In my job i am supposed to extract data from SAP and load it into Oracle.. We tried using ABAP stage to get the data from SAP.. I want to know abt BAPI and IDoc and how it is different from ABAp.. in which scenario i need to go for what.. is BAPI used for loading data into SAP and ABAP for extr...

Thanks a lot for the information... So even in 8.0.1 version copy, modify stage are preferred to Transformer..!!! :D

You mean to say a Transformer is advised to use instead of a copy stage..
In 7.5x we prefer a copy stage instead of a transformer..

In 8.0.1 a transformer is preffered instead of copy..?? How does IBM justify this.???

Hi.. We have been developing some jobs using datastage 8.0.1 version.. For some small modifications we had to achieve,we used modify stage. But our Onshore has asked us to replace it by Transformer.. we have been advised to use Transformers for even small operations like copy, modify etc.. We have b...

I have a look up file that has abbrevations for certain columns and their respective expansions.. my source need to look up on the abbrevations and need to fetch the expansions.. This is quite simple.... However in my scenario i have the same abbreviations that have multiple values.. eg.. NOL -NetPr...

Hi, I would like to know why we need to explicitly specify the number of readers per node for Seq file stage.. What implications it has in performance..??? How do i decide how many readers per node?? There is also an option which says read using multiple nodes- Yes/No..??? I would like to know abt t...

When ever my DS jobs runs successful I need to give out a message.. This messgage shud be displyed by creating a file in C: drive..
The file must contain the value "JOBNAME is success"

where as JOBNAME is the name of job

An output sequential job is created in my DS Job. In the first line of the sequential file I want the line" This file belongs to XXX"
where XXX is my job name

keshav0307 wrote:Lavanya ---what is your thought on this, what did you tried? have you created any job for it? what is that job doing?

Well I am still doing it.. .. Shall keep you guys posted.. thanks for coming up with different ideas