Hi All,
We are using DataStage 8.0.1 and Database is Teradata on Unix platform.
As a code review, I want to find all the jobs in my project that have a Target TD Connector stage and in which the Write Mode is not "Truncate".
I tried taking two test jobs in which I have one target TD connector stage each.
In first job I kept the Write Mode as Append and in the second job I kept the Write mode as Truncate.
Then I exported the jobs and tried to find out some patterns that can identify the Write Mode.
I used the pattern "GenerateTruncateStatement" to search for the table that gets loaded in Write Mode as "Truncate".
But I could find that patter present in both the dsx files.
One thing that I observed is, There are two instances of pattern "GenerateTruncateStament" in the dsx where the write mode is Append. I found 8 instances of the above pattern in the dsx file where Write mode is Truncate.
I tried taking two target stages in a job each having Write Mode as "Truncate". Here I got 16 instances where the above pattern is present. Then I took three target TD stages and in the export file found that there are 22 instances of The pattern "GenerateTruncateStatement".
I was expecting 24 count logically in this case. If that was the case I could determine exaclt logic behind identification and could have written a small wrapper to find the jobs by scanning the Export of jobs.
The strange thing that I observed is, in the export files where I had kept two/three target stages with Write Mode as Append I could not find any instances of "GenerateTruncateStatement". This is quite obvious, but then why do I have 2 instances of above pattern present in the file where there is one target TD stage with write mode Append????
Can anyone please help me what approach should I follow to identify the Write mode of the target TD stage is not Truncate?????
TD Connector Stage
Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 20
- Joined: Fri Jan 27, 2006 12:17 am
Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration