Skip to main content

Posts Tagged ‘Datastage best Practice’

Digitally Enhanced Shot Of An Attractive Businesswoman Working In The Office Superimposed Over Multiple Lines Of Computer Code

HTML In DataStage

We use different formats (sequential, XML, etc.) as a source or target in ETL jobs. In some cases, HTML is needed to create the output file. What is HTML? HTML (Hypertext Markup Language) is a text-based approach and the foundation of a website. It is the backbone of a website that creates content in a […]

Most Common Points for DataStage Jobs Performance Tuning – Part 1

The following are the points for DataStage best practices: Select suitable configurations file (nodes depending on data volume) Select buffer memory correctly and select proper partition Turn off Run time Column propagation wherever it’s not required Taking care about sorting of the data. Handling null values (use modify instead of transformer) Try to decrease the […]