DSXchange

Ray you shall add you valuable inputs to this thread, which will be useful for those who have not access to DataStage Essentials class.

Try toggling the parameter type 'Encrypted'/'String' in the job property for Password parameter.

Hi Diego,
Were you able to connect to the MS SQL Server directly from any of you GUI or command prompt?

I have posted it already, so I guess I might have taken it from Orchestrate manuals.

Hi,
You may not have 5.x server, but if you can check the key and mapping of the transformer in 7x if imported correctly and not changed after that.

Even during you View data, it might have prompted for password, did you gave the same value?
Was any NLS been enabled for that job?

True, aligning to this format took a long. Atleast once.

If the key that you use for JN1 until the remove duplicate stage are the same, the you just need to sort before join once, and maintain the partition ('SAME'). To avoid fuzz, partition the data by HASH method before the sort based on the key, and maintain the SAME partition till the end. If the Dupl...

Join Lookup Merge Description RDBMS-style Source and lookup Master table and one Relational tables table in RAM or more update tables Number and names 2 or more inputs 1 source and N lookup 1 master tables and N Of inputs tables update tables Memory usage Light Heavy Light Handling of Ok, produces ...

Is this the exact error message you get when you run the job?
As mentioned earliar, have you checked whats the value that been passed as password, when you run the job from Director entry.

To get the count and the list of file names with some pattern, you can use ls in that directory coupled with wc as well. Use sed or awk to fetch the file name is the required pattern.

As mentioned you need to give out the full details before asking for a solution. The exact error/ warning message. Before that you can check with the basic troubleshooting steps. Was the password marked Encrypted and not passed accordingly. Check by passing hardcoded passwords. Check the director en...

Why cant you import the Imported table definition into CFF stage?

Execute it without Userid.

Check the fields that mentioned as Key in each Aggregator is sorted before that stage.