DSXchange

Hi While doing lookup between db2 database and dataset as ref. getting 2 warning messages 1) Lookup_CNUM: When checking operator: Operator of type "APT_LUTCreateOp": will partition despite the preserve-partitioning flag on the data set on input port 0. 2)Lookup_CNUM,0: When binding input i...

Hi All

We have some environmnt variable defiened for our project like PROJDATADIR etc. I want to access those environment variable in my AIX script . So how can I do that ? How can I get the values of those environment vairiable in my script.?

hi
I am using setnull() and both source and destinition fields are of integer type

Hi In my source .csv file a field if null is indicated as null (small caps without quots) and in my target file same filed is nullable = true I am applying the If field=''null'' then set null else field value (I have to apply above if then else ) But I am getting Xfr_Map,1: Field 'field_name' from i...

From one of Ray's post.. thnx you very much ..... -------------------------------------------------------------------------------- Warning - Technical Content The reference input to a Lookup stage for a normal (not sparse) lookup causes a composite operator to be generated to perform two tasks, for...

From one of Ray's post.. thnx you very much ..... -------------------------------------------------------------------------------- Warning - Technical Content The reference input to a Lookup stage for a normal (not sparse) lookup causes a composite operator to be generated to perform two tasks, for...

devidotcom wrote:Yes it will.

thnx for reply but can you exlain it how....

if we use a lookup stage the reference data gets looked up in the memory. Just a query here ....in case we use Lookup File sets as reference for a look up stage....would it still act as an overhead to the memory....

thanx in advance

In my before and after datasets have same identical data still change capture stage showing some records as edit ? what is the reason for same? It could have anything to do with having NULL values in so many of the key columns ? but there is absolutely nothing in the DataStage or Orchestrate documen...

Hi In my job I am ding lookup with 7 tables using lookup stage .. While executing I am getting some warning as below Lookup_1,0: Ignoring duplicate entry at table record 345,699; no further warnings will be issued for this table How can I find from this warning exactly for which table I am getting t...

just getting message general syntax error ...

can you plz provide me the example of DSSendMailTester as I am getting syntax error again and again ...

Hi I want to send a mail notification if any job in Job Actvity in sequence ends with warnings. But I dont wants to use mail notification activity stage.So how can I do it ?Is it possible on Cstom trigger type in Job activity stage through some expression... If yes then how can I check whether job e...

hi, i already worked in informatica now i m working on datastage... i know how to load fact in informatica.. it goes like this... source-- SQ ---lookup1 on dim1 SQ----lkp2 on dim2 SQ----lkp3 on dim3 -------- Expression ----- target SQ-----lkp4 on dim4 can anybody pls suggest me how it will look in d...

Hi All In my project there is one master sequence job say A which calling other sub-sequences say a1,a2,a3, a4... in mentioned order Due to some reason sequence job called by a2 is failing and due to that master sequence is getting aborted(i.e. sub sequence a3,a4 are not getting executed). But we wa...