DSXchange

I really wanted to avoid the dsjob with a script but that might be my best option. One last thought though. When you us DSJOBINFO in a transformer will it only work for the job that is currently running? For example what if I have a list of jobs and I pass them through the transformer. I then call D...

Is this information not stored in a universe table? Is it possible to extract it with an ETL job that selects via an UV stage?

I dont do it in the sql i do it in a transformer. I have tried it within the sql but im not sure if im using incorrect syntax but that doesnt load either

IVR,0: Warning: IVR: [DataDirect][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ':'. IVR,0: Warning: IVR: [DataDirect][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. APT_CombinedOperatorController,0: Failure during execution of operator logic APT_CombinedOp...

INSERT INTO IVRPolicyDataMart.dbo.Policy (SourceSystemId,PolicyId,PolicyEffectiveDate,PolicyName,Company,LineOfBusiness,PolicyStatus,PolicyIssueState,PolicyAddressZip,CreateDate,LastUpdateDate) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11)

I am trying to load data to a sql server db. I have been successful loading data to a table without dates through datastage. I have also been successful with adding rows through query analyzer. My issue is that in my job my dates have the following format as a varchar(8) yyyymmdd. I try to pass the ...

I depends what the return value data type is. could be null or in some cases it is zero

Your better off waiting until IBM comes out with their release. The Ascential version is not that good and you cant really move away from the path the profile stage puts you on. I ended up using it for about 1 month of my 4 month project and then after that I started just writing my own custom sql a...

If the fiel names are going to stay constant or then number of files is oging to stay constant why not just have a before job that runs in unix to cat the files together prior to the job starting

I would just convert the date to a julian day and add 1 then convert it back

I have a field in the following format: 50% (ABC: $1,000) 100% (ABC: $5,000) I want to parse this into 2 columns so that the result looks as follows A B 50% $1,000 100% $5,000 Is there a function in data stage or a combination of functions where I can look for a % or a $ and then take everything to ...

if it is a constraint on the output of a transformer you only pass a record through if the input field REJECTEDCODE = 0 and if Field1 is not null

I have run into the exact same issue and after talking to support they will not even listen to the problem if you are not use the ascential drivers. with that said I still can not connect to an oracle db through profile stage.

My experience with profile stage has not been that good. Ascential does not seem to be too familiar with the product and there support is far from superior. With that said, if you are looking to pull null counts, distinct values and other very simplitcis measures then profile stage will work for you...

Yes I do Have Read Permission on the tnsnames.ora file