DSXchange

Sorry..I ran the command with the password in it so it worked!

After logging in as the same user as used in the script (userval) , it is not running.
On the command prompt, it is asking for password to be typed in

No I was not.
It is running now. Thanks Paul :(

Hi All, I am trying to execute a job from a script using dsjob and it works fine when I a pass the password (project name and job name are passed as params) dsjob -domain domain -server S1 -user userval -password pass -run -mode NORMAL -warn 1 -wait $PROJECT_NAME $JOB_NAME We have Active Directory I...

Hi All, We are migrating from 7.5 (Windows) to 9.1 (Windows) on a new server. We have 5 different projects and all are using only Server Jobs. 1. We have a lot of Hash files. Is there a way we can copy them from the 7.5 environment or do we need to create them as new ? 2. The Hash files are all in o...

Hi All, We have been trying to finalize the source extract delimiter but the source system seems to have most characters like | ~ and so on. We were thinking of using Double Quotes around every field in all the extracts to take care of this issue there is a likely hood of even " (Double Quotes)...

Thank you Chulett and Franklin for the detailed response.

Franklin, I was thinking of Child Sequence only in context of NON Check Point Approach. But based on the comments I will got above I will definately go with the Check Point approach.

Hi All, Designing the ETL cycle for Restartability. The Main Sequence (that controls the end to end ETL cycle dependency) job will be invoked using a Wrapper script that does initial validation of the state of the job and resets accordingly and generates logs file. One Child Sequence job will contro...

Hi All, When we use Balanced Optimizer for SQL Push Down into the Database (Netezza in our case) will we still be able to get the Operational Metadata information from the Operations Console as we would expect to get for the Original (Pre BO) job? e.g. I mean information like rows per link Thanks, NV

Thank you all for the information. This is very helpful

Hi All, we are new to Business Glossary. We wanted to understand if there a general guidelines/best practices on how we configure the security around it. Like how best to group users based on different roles that could use the tool. I know there is no specific info here on type of usage, but any inf...

Hi All, we are new to Inforamation Analyzer. It has been installed and we wanted to understand if there a general guidelines/best practices on how we configure the security around it. Like how best to group users based on different roles that could use IA. I understand there is no context here, of h...

Hi, Server Jobs to Server Jobs Migration (No Parallel jobs for now!) We were planning to migrate from on old version 7.5.2 to Information Server 9.1 but now we see 11.3 is available as well. For 11.3, Deprecated features, explains that they are no longer supporting Unidata 6, but will still support ...

Hi All, When migrating from existing Datastage v7.5 env to Infosphere v9.1.2 (fresh install on new hardware), is there anything on the Websphere App Server that needs to be considered as part of this migration? I believe WAS will get installed during the Infoshere Information Server Install but do w...

Thanks Ray. I see in version 9.1 (Server jobs) Unidata 6 stage has been superseded by Unidata stage. So does this mean 1. This job will not compile post exporting/importing from V7.5 to V9.1.2? 2. Will we need to re-design the jobs to use the supported Unidata stage or it will continue to work (with...

Thanks Chulett. Also currently our Target DB is SQL Server 2005 (in v 7.5) and we plan to move the DB to SQL Server 2012 Standard Edition post migration to v9.1.2 So will we need to change the job design (compile will fail?) to use the new Stage in 9.1.2 to connect to SQL Server 2012 as the stage us...