DSXchange

Thanks a lot Ernie Since you are already asking for the details from each of the two groups, just add the columns you want by hand: SourceCountry ...... /...../...../..... etc...../SourceGroup/Country/text() and TargetCountry..... /..../..../....etc ..../TargetGroup/Country/text() It "looks&quo...

Did you get anything at all? This should yeild an error because there is no key selected for your repetitition element. Tell us what happens when, for example, you make Country under target group your repetition element, and then be sure that "repetition element required" is unchecked in ...

I have to extract values from all MappingElement ElementId in following XML File. <Response> <Header/> <XmlTransaction> <TransName>MAP</TransName> <Completiontext>Successful</Completiontext> <CompletionCode>1</CompletionCode> <ReferenceMapping> <AppSource>XX</AppSource> <TargetSystemId>YY</TargetSys...

I have a Sybase stored procedure which does insert in 3 tables. I am calling the stored procedure using SYBASE OC stage. I need to capture Successful completion or custom error code and message thrown by the stored procedure . These informations are inserted in the tracking table. I am using Followi...

Following are the list of null handling function i found in help of datastage/ Parallel section HandleNull IsNotNull IsNull NullToEmpty NullToZero NullToValue MakeNull SetNull will these work in Server jobs (Transformation)? How to handle null value for date type column (target - db2) ? e.g. Default...

You are trying to make 2 records out of each set of 7 records? Or do you only need to produce the 'heading' row once? :? Lets talk about multi value flat file Input IssuingCompanyCd,013550 PolOfficeCd,000130 PolicyNo,WR101 CertificateNo,101010 RenlCertNo,000000 EndorsementEffDt,01012008 Endorsement...

I am trying to make 2 records out of the 7 records 1st Record contains first columns of these 7 rows 2nd Record contains second columns of these 7 rows. Could you please give me more details? You would need to use stage variables to (ultimately) build a concatenated record (including field delimiter...

I am getting data in sequential file as follows Input IssuingCompanyCd,013550 PolOfficeCd,000130 PolicyNo,WR101 CertificateNo,101010 RenlCertNo,000000 EndorsementEffDt,01012008 EndorsementSqn,1 Want Convert Output Sequential File like the Following Output IssuingCompanyCd,PolOfficeCd,PolicyNo,Certif...

Workunit in this case is Insurance policy We need to move this insurance policy transaction from one transactional database to target transactional database. we are using staging database with similar structure as target. Transform the data from source load in to staging. from staging load all the t...

Transaction handling with commit and rollback is a good and nessary feature of all databases. It was and is intended for normal database usage as to insert one order at a time which has several tables. You can use this feature also within ETL-processes, but for that purpose it is in my oppinion a c...

Again, 'transaction rollback' can only happen under the following circumstances: 1) You have not yet committed the records, so 'Transaction Size' is important. Typically, that would mean using a setting of zero. 2) The job aborts. Period. It must abort in order to rollback all uncommitted work. The...

As noted, you'll need to not use transaction grouping but rather a transaction size of zero. And then ensure that if there are any errors the job aborts, which will force the rollback. Various ways to do that - run with a very low warning limit threshold, use a reject link set to abort after 1 reco...

You can't use 'transaction grouping' if you want an 'all or nothing' style load. It forces the transaction size to 1 so that each 'unit of work' is either commited or rolled back together. If you want all or nothing, uncheck the grouping option and use a transaction size of 0 for all links. I want ...

Sorry for any confusion caused ODBC Stage captures errors if there is any key violation but does not capture error such as target column does not allow null values. Error Message Captured though Sybase OC GdbgStg_GD_openclient..xfmStg_GD: At row 1, link "loadGDTpolicy" Sybase Server messag...

Yes My Test Job Looks like this On my target there is a column which does not allow null values. Job status as well as log shows the job ran successfully. no rejects If check the table i don't see that row. If I Use Sybase OC Stage instead of ODBC the same row gives me following Error Message(Target...