DSXchange

Dears, i really have a serious problem since a bout 1 month , i searched a lot and a lot about it but don't found any solution , i tried to connect to sql server 2005 using Enterprise ODBC stage or Dynamic ODBC stage to read or write , but where running i got the follwoing Error loading "orchod...

the Surrogate Key will do the same behavior if it is operat in parallel , to resolve that you should use either the Surrogate Key or the Tansformer in sequential mode If you are saying that the Surrogate Key Generator stage will "do the same" if not run sequential, as in not produce uniqu...

the Surrogate Key will do the same behavior if it is operat in parallel , to resolve that you should use either the Surrogate Key or the Tansformer in sequential mode

Hmmm... perhaps match based on three, allow multiple values to be returned from the lookup, order by length desc and take the first match per group? :? ... that is great idea , but unfortunately it won't work for me , because when takingthe lookup on substring of 3,it will give many results which s...

As far as I know, you'll need cascading lookups - five of them set to continue if they fail. First one checks for a substring of 7, the next 6, etc. ... Many Thanks chulett for your reply and interest , i've thinked in that but is there is any other method to make it dynamicaly , i'm afraid of any ...

hi, i have a new challenge in using lookup stage , i want to do the following * in a lookup table i have variable length data from 3 to 7 characters length , each character represent an information , my stream data contains a little longer string , which i want to lookup for a substring of it starti...

kbsuryadev wrote:Check the INDEX function in DataStage

how to use index function within lookup stage , in order to lookup a portion of a string ? kindly illustrate

may be the data type is not integer , may be it is decimal , trye to work to validate that

i agree with what chulett said , i also was confused about that before , but now take it as a rule , the mask for the function is telling the function how the input is passed to you and further the function understand the input to manipulate it

Thanks for the reply. But I solved it another way. I inserted the values in table B by enclosing the column B values within the wildcard characters '%' . For example, instead of inserting 'MB', I inserted '%MB%' and then wrote the following SQL Query Select * from A, B where A.A like B.B I guess th...

The first thing you need to do is to get some solution for just one job that works. Once that is done you can figure out a way to generalize that solution for the whole project - this might involve doing a project export into a .dsx file and a global replace or perhaps even more involved manipulati...

Check that the data is sorted and partritioned with all difference keys , use the proper partitioning method , hash partitioning is recommended if you have multiple difference keys

hi, I've a problem in designing a job which need expert opinion in how to design the story is as below simple i need to design daily job which which will read about 1 billion records may be increased to 1.5 billion record within few months, rank them with the transaction date , gets the maximum tran...

anandsiva wrote:IBM has agreed this as a know bug and they are going to provide a patch for this issue.

could you please clarify where exactly is the bug ?

Regards

i also don't think that you need to fo this check which say if something is null , then set it to null ,,, i don't think that this thing is meaningfull