DSXchange

Hello,

Can someone please let me know if DataStage has any connector for Tibco MDM ?

thanks in advance.

In the same job we have both stages one to insert and one to update. And it is not a multi instance job.,

Hi All, I am facing "MLoadTask is not running" error while loading into a table of teradata. But if will finish fine if I restart the job after sometime. In some cases i had to wait more than 12 hours for the job to finish successfully. TeradataConnectorPX stage is used to Insert and anoth...

Can you read all the files as file pattern ? Or you need to process only one file in a single run ?

You can club start date and end date together in a transformer, after extracting from source.

could you please elaborate what is WAS process ? The good thing is the server is up now ,issue resolved.

Still like to know the reason behind that.

Hi all,

all users are getting below error when tried to login into datastage designer.

Please let me know the reasons for this issue. Appreciate your help.


Failed to authenticate the current user against the selected Domain:

Version 8.0.1


Thanks,

Hi All,

Am facing an error with DRS stage when given environment variables but runs successfully when given job level parameters or hard coded values.

Interestingly "View Data" works perfectly fine for all options.

Could you please let me know what could be the reason ?

Thanks,,

lets say we have a table with columns a,b,c,d and you would like to pivot the data on column a ,(b&c&d) then you would have 3 records for every one source record (assuming all columns have values at source).

source:
a b c d

target:

a b
a c
a d


--
Elias

if the source is a table then you can use sql funtions to convert hexadecimal to decimal in a better way.

ya it was a double post, but i could not find a way to delete this post.Please throw some light .

Anyways if you know the solution please let me know.

Thanks,
Elias.

i haven't defined the variable at admin level.I have created a parameter set.
I understand if it was a environmental parameter we need a $ to access the parameter.But i was referring to a parameter in parameter set.

Hi, Parameter set name :test parameters in parameter set :schema Used in SQL of RDBMS stage as test.schema When i check the data by "view data" it works fine and I can see the data as well.But when i execute the job an error is occurred as below. Dynamic_RDBMS_0,0: Info: jobname.Dynamic_RD...

Hi, Parameter set name :test parameters in parameter set :schema Used in SQL of RDBMS stage as test.schema When i check the data by "view data" it works fine and I can see the data as well.But when i execute the job an error is occurred as below. Dynamic_RDBMS_0,0: Info: AP_TRANS_SAP_SAP_C...