DSXchange

I'm doing a job that FTP's files to a windoze server. High level, heres what it looks like... FlatFile ----> Transformer ------> FTPStage I get the following error... TaUpdates..FTP: Error while trying to open connection for sending data to the FTP server, FTP command PASV failed Has anyone seen thi...

I have a interesting file that I want to read in. I would like to know if there's a way to read in this kind of file.... Here's a few lines from the file. You'll see that there are spaces, empty lines and data in various formats with different number of columnsm types and lengths. Account Pricing Pl...

Is there a way to import hashed file difinitions when it is not saved in the Account name, rather in a directory path? This can be done simply with flat files....... I know that you can save the definition in the job where the hashed file is created. I'm looking for a shorter, quicker way.

There is a requirement to start up a Datastage project that was exported and deleted. We've re-imported the jobs no but can't do anything (cannot edit, compile, save, etc.) as they have somehow been protected. I don't know how protection works in DS, nor how to work around the problem and get the pr...

Were running Datastage AIX. I need to extract from a Pervasive database. Whats the best way to connect? So far, we've used ODBC on other sources but I havnt found an ODBC driver for Unix yet.

I have always felt that source / ERP systems should store data as uppercase to eliminate duplication and redundancy as much as possible. This is not the case in our organization sot I've suggested to the ETL team that data be extracted as uppercase for the DWH. What is the best practice around this?...

The problem I have is with the JobToRun parameter component. I can't get it to substitute the correct value at runtime. Assigning the parameters to the job works ok. I do this by removing JobToRun and replacing it with the name of the job I want to run. e.g. UtilityRunJob('LoadCustFact','Project=':L...

It is possible to export your datastage project via the command line- something we do on a regular basis. DS just doesnt export the schedules. What us the best practice around backing this up? What we dont want, it so have it documented somewhere in a spreadsheet. What we do want, is for it to be ea...

I haven't figured out how to use a job parameter inside the UtilityRunJob utility. Given the following scenario. Current jobname: JobParameters Current job parameter name: JobToRun Inside of a transformer stage, I have tried the following derivations: UtilityRunJob('#JobToRun#','Project=':Link1.proj...

I have 2 jobs, xxxparams and qwertyparams. In a transformer, I create a stage variable, var1 = DSJ.ME and get the name of the jobs - ie xxxparams and qwertyparams. I need a function that will clip off the 'params' part from the end of the jobname dynamically. Any ideas? Just to make it clear, I need...

Thanks Kenneth. Perhaps I was a bit unclear in my initial post. I have a type2 dimension with delimitting dates and would like to do a lookup against it for populating a fact table. Say, for example, I have a hashed file with the data from the dimension. A record is made unique by the combination of...

Does anybody know how to do a lookup against a type 2 dimension within a transformer? If done in sql, the where clause would use a bewteen e.g where source.tran_date bewteen lookup.from_date and lookup.to_date and source.id = lookup.id I have a lookup with a composite primary key on id, from_date an...

After all, I was able to do it. I created a transform routine, using the oconv funtion to get the system date and calculated the derivitives of the date I needed. In the sequencer, I used the RoutineActivity stage to call the transform routine and assigned the returnvalue to parameters of other jobs.

I have some code that generates various dates from the DSGetJobStartTime function.I write these into a parameter file.I then read these from the file in a coded control job, assign these to variables then to other job parameters (DSSetParam).This way I do not have problems with choosing correct para...

Odata warehouse started in 2002 so the first date in the date dimension has been 01/01/2002 with a surrggate primary key of 1. Now we have to integrate other data into the data warehouse. The date dimension needs to be updated with dates back to 1994. Numerous fact tables have been created. What is ...