DSXchange

Hi, Any suggestions for EL tools "out there"? Freeware would be great, otherwise cheap. Something that would just copy data from ODBC Source A to ODBC Source B, without any transformation, that would be quick and easy to use? We often have need to just do a "bulk load across databases...

Hi Craig, As an ETL language , I really really like SAS. IMO, I can do much more complex data transformations using SAS than DataStage, especially OOTB. So as a language it's rock solid, and has been used in major, large datawarehousing projects around the world. However, there's the old saying &quo...

Anything stopping you from actually using SAS for this? :wink: Yep, two things: 1. While we do have SAS, it's on a restricted license, supporting a single application. 2. Sybase ASE --> SQL Server is fine, but Sybase IQ --> SQL Server would require the ODBC drivers, which unfortunately we didn't li...

Hi, We need to copy many tables (say 50) from Sybase to SQL Server. The tables have IDENTICAL schema. It's just a straight copy across databases. Do I need to create 50 jobs, or can I have a "template" job with the name of the tables passed in as a parameter? This would need to support a s...

I tried If Num(Column)=0 then Column else 1 Now all the fields are getting populated with 1. I think your logic is backwards... The DataStage Basic Guide states (you DID reference the Basic Guide before writing your code, right???): Syntax NUM (expression) Description Use the NUM function to determ...

vasubabu wrote:where can i diffine the parameters to connect to another server filesystem.

It's at the operating system level. Type "windows map network drive" and "windows unc path" into Google.

Two questions, one answer. Batting 500. ROTFLMAO (Sorry for the acronym Ray :) It's probably not "business level" English either!) deesh, what Craig is getting at is if your source data is "FOO " and your lookup is "FOO" you won't get a hit. This one has bitten me in t...

See viewtopic.php?t=126366&highlight=

Hi Mike and Craig, From your two replies, I assume there's no way I can get DS to mimic the SQL Server client. An approach Ray told me is to do two passes...as Mike said, parents then children. I'll insert all data except ParentCustomerNumberSK, and in that transformation write a hashed file of the ...

Hi, I have a SQL Server target table (DRS stage) containing CustomerNumberSK and ParentCustomerNumberSK columns. The ParentCustomerNumberSK is derived earlier in the job stream via a table self-join. ParentCustomerNumberSK can be repeated and can be null. IOW, the ParentCustomerNumber (natural key) ...

Perhaps this will work?

iconv(YourVar,"MD2") / 100
iconv(YourVar,"MD3") / 1000
iconv(YourVar,"MD4") / 10000

etc, depending on the number of decimals you want.

See the examples for iconv in the Server Job doc.

HTH...

Anyhow thank you for your response, I think I'll have to build a job to do the required task :idea: Check out http://www.duke-consulting.com/DataStage_Tips.htm and http://www.duke-consulting.com/Downloads/EtlStats_20060704.zip. Even if you want to customize the code, this would be a good starting p...

Anyhow thank you for your response, I think I'll have to build a job to do the required task :idea: Check out http://www.duke-consulting.com/DataStage_Tips.htm and http://www.duke-consulting.com/Downloads/EtlStats_20060704.zip. Even if you want to customize the code, this would be a good starting p...

foo = "DSU.MyRoutine" Call @foo(Result, other_args) The technique is called "indirect call". And it's in the DataStage BASIC manual. I've used it in the past to create data-driven business rules validation. For functions the first argument position is reserved for the return val...

The fact GL4Product is missing from your GoSub labels isn't helping. Thanks Kryt0n. Yeah, I found this about 10 mins ago. Was confirming before posting again. I discovered this by putting additional debugging stubs in the GL4Product subroutine, then noticing they weren't echoed in the log. Well, do...