DSXchange

You can even use odbc or DRS stage for any database, but these stages lower the performance. ODBC is not necessarily slower, maybe it doesnt provide all functionality that a Native API stage does with the respective database. Anyone whose been through Data Direct's wire protocol ODBC driver documen...

Yu can use RANK /ROW_NUMBER functions if you are extracting from Oracle database, refer Oracle SQL Guide- freely downloadable from OTN. Similar database functions may exist for others.

We would like to do this lookup mapping work for lot of jobs, and wanted to finish as fast as we can....

Add more developers .. Yeah i know management has the usual shortage of budgets and business has the urgency..

Threaten to gracefully resign and ask management to do the development ..

Use a Before Job Subroutine and call and automated FTP or SCP script to copy to a local folder, then use External Source to cat the file contents to its output link and pass this output link to XML input

DB2 target on the host side. Which platform at the host side? Im sorry this forum may not be the best place for quick answers to global questions .. you will need to do some work on your side of the question, and probably ask the client . That being said , we are ready to answer specific TECHNICAl ...

I have a solution using server jobs, you can try to convert it to parallel( Shouldn't be a great deal)- Im not

Thanks
Ramesh

Does your manager know about 'IBM Passport advantage' or NLS? Have you listed down assumptions about data quality from source systems?

You can use a code snippet similar if you have a job handle attached. CurrentJobHandle = DSJ.ME /* CurrentJobHandle= DSAttachJob(JobName,DSJ.ERRFATAL)*/ TargetEnv = '$TARGET_ENV' TargetEnvValue = DSGetParamInfo(CurrentJobHandle, TargetEnv, DSJ.PARAMVALUE) Ans = TargetEnvValue In the example above $T...

Hey thanks, i logged on to the admin console and added a new user, im able to log into Designer using the new id.

Hi All Im new to Datastage 8.01 and we are having problems logging on to the datastage server via DS Clients( Designer/Director), however we are able to log into the information server console. We get an error message saying that "Failed to authenticate current user against the selected domain&...

I have never encountered such a 'requirement' before.
Was that an 'interview question' by any chance?

Otherwise I'll second WomaWil's approach.

Now, does this work in the OP's scenario where the Environment Variable has been defined not just in the .profile but in the Administrator as well? Meaning, it allows a locally set value to override the Project's value? Well apparently yes, because my example had a default value already set in admi...

You need to to set the environment value outside datastage in your user profile, and launch the job from the project directory using dsjob -local option Example ( From unix command line) $ export CenUser=cogapp; $ dsjob -run -mode NORMAL -local -param $CenUser='$ENV' neo_sap_dev2_752 SAP_FinanceWarr...

A look at how PX jobs in Ver 8.x can handle SCD type 2
http://www.leverageinformation.info/myA ... sdatastage

Isn't there a way in which you can use a WaitForFile Activity?
Otherwise you need to extract the Command.Output and parse it subsequently in the sequencer ( As noted)

HTH