DSXchange

two questions 1) So in a 32 bit machine with a heap memory of 2GB, Is it safe to say we can go for a lookup stage if the reference data is 1.00 GB? 2) So in a 64 Bit machine, where heap memory has no limit ( if i understand correctly) , what is the safe bet for the limit of reference data if i want ...

Hi
One basic question,

I know it is better to use lookup stage when the amount of reference data is
is not huge, but how big is big, based on what the reference data is
considered as big or small, is it based on RAM memory availability or
something else

your response is appreciated

cheers
MJ

Hi thanks for responding.. the queries are dynamically generated... and i want to use those data in the job. I think by somehow i have to generate the columns of the sql queris as a single concatenated columns and separate them with commas andand as craig said i should then union them all, before pa...

hi craig, thanks for responding, tried that too.. its not working..

Hi I did some googling and searched this forum as well, but couldn't find it. I'm trying to execute multiple sql's in oracle stage using the "Load SQL from file at run time" option, seperating each sql with a ";" , but datastage is taking all the sql as a single SQL and trying to...

I'm inserting records into oracle oci stage, whenever the insert fails for whatever reason
i need to capture that in a sequential fail of the rejected records, i tried adding a sequential
file at the end of the oracle oci stage but i couldnt find any reject options, can anyone help me?

thanks

Hi
Is there any way i can use a sequential file column value in a SQL query?
like.......

Oracle SQL Query
===========

insert into tablename1 ( col1)
select col1
from tablename2
where col2 in ( dslink.col1)

thanks craig

craig, thanks for responding, I dont have much exposure in server stages, its seems like the server aggregator needs the data to be sorted, i have now tried simulating the same scenario, i'm getting "row out of sequence" error, is it because the aggregator is getting non sorted data?? corr...

Hi I don't have access to Datastage now, can anyone please help in giving some clarity on this, i have a job as input_seq_file --> aggregator --> output_seq_file some string columns in the input file are sorted as numeric using the unix command before it gets processed in the aggregator, my question...

ya i understand that, but i dont know why datastage is prefixing the pwd on top of the path i specify???any idea???

Hi all I tried placing the file where datastage is getting pointed to C:\IBM\InformationServer\Server\Projects\Training\Datastage\Testinputfiles\ its working as expected and i can see the data in the peek stage and in the seq file as well when replaced, so the only question here is how to change the...

hi erine.. whatever i have pasted below is the only thing in the XML document. and FYI, when i see the director log, the variable PWD is assigned as below PWD=C:\IBM\InformationServer\Server\Projects\Training i couldnt find this in the environment variable section, may be datastage is picking this p...

hi.. This is the XML file i'm using in my job http://msdn.microsoft.com/en-us/library/windows/desktop/ms762271(v=vs.85).aspx i tried to find what is schemalocation attribute and it seems like there is nothing in the XML file as such, correct me if i'm wrong... and FYI, i have disabled "validate...

Hi I tried as External source ( without wild card) > XML input > peek stage and i have enabled tracing in the job External source config: =============== Source Program: ls /Datastage/Testinputfiles/XML_in_Books.xml Output in the tracing for external source ========================== XML_Input_26.DS...