DSXchange

Thanks to all for the help. The issue with the registry is reolved. In my case i was using a single server architecture . If we have to use the LDAP Regaistry for Datastage then PAM with only Engine Tier Configuration will work. Service Tier Configuration is not required. I did the same and it worked.

Thanks Rodriguez

Do we need service tier PAM configuration along with engine tier pam configuration or only engine tier Pam configuration will work ?

ray.wurlod wrote:Looks to me like you've missed the Engine Credentials step. ...

Thanks Ray .. but i used the Shared option there. "Share User Registry". So there is no other option to map.

Hi I am using 8.7 Version of IIS. WAS , Engine , Metadata Tier all in same AIX 6.1 box. I am able to use the MS active directories (AD) as the authentication process. I am able to access Business Glossary , Metadata workbench, Fasttrack using LDAP authentication. The challenge , i am facing is with ...

Hi I am trying to install the Datastage 8.5 Client in Windows XP 32 Bit System. Downloaded the 32 Bit Client and ran the setup.exe. First ran without changing the default framework which is .Net 1.1. Ran into error. Uninstalled as per the microsoft guide. http://support.microsoft.com/kb/824643/en-us...

Hi Guys I am getting a compilation errror. Here is the details of environment. 1. Datastage 8.5 64 Bit 2. SQL Server 2008 64 Bit 3. SQL Client is 32 Bit. 4. Windows 2008 64 Bit. I ran a sample job which doesnt have Transformer and it ran fine. When i included Transformer ( just direct move - no conv...

I have a table called "Test". Data in the Table is : Test -------------------------------- Col 1 | Col 2 | Col 3 ------------------------------- 123 | abc | test0 223 | dcf | test2 123 | abc | test3 I want to generate the surrogate key based on the values in Col 1 and Col 2. When i am gene...

you can use convert function ..convert the special charater to spaces and tri off. Inorder to convert use the ascii table

I think that Database should also support the same NLS Format.

Here is my data in column n1 : "Hello World" and " Hello " Here is my syntax : 1 . n3 : string = string_trim (n1) 2. n3 : string = strip_whitespace(n1) 3. n3 : string = trim_leading_trailing(n1) This is not stripping the white spaces. Data stage is running on AIX 3 5 Thanks manish

You can use NulltoEmpty() function also and then compare . I should work.

Seems the Trim functions doesnt work in the modify Stage. i tried the option in Orchestrate manual and also tried the one given here , but it is not triming the spaces. I used string_trim() and also tried with strip_whitespace () and trim_leading_trailing command. it doesnt work Please let me know i...

Seems Either Key column name( ie is the one you are generating using the Surrogate Key Generator) is not there in the Target table.

Seems Either Key column name( ie is the one you are generating using the Surrogate Key Generator) is not there in the Target table.

There is no Need of "%". Ny default it will put that in this format.

ray.wurlod wrote:Don't you need percent signs on the time components in the format string also?

Code: Select all

%yyyy-%mm-%dd %hh:%nn:%ss
              ^   ^   ^

...