Blog Index Page

All Datastage,Unix,Database Related Information,Problems and Solution

*Click here to attend Online Web Datastage Training Sessions- Learn Datastage in 25 Hours

*Click here to know IBM Datastage 11.3.x Newly Added Features
*Click here to know : Datastage Engine Performance Tuning Tips:UVCONFIG
*Click here to know : Change wasadmin password:Disable global security
*Click here to know Datastage Scenario Based Question/Answer : 3
*Click here to Datastage Scenario Based Question/Answer : 2
*Click here to know about Error 6 initializing SQLPLUS Error in Unix/Linux
*Click here to Check if Datastage Project has any corrupted files or not
*Click here to know Resources unavailable to create a Datastage Job
*Click here for datastage scenario based question answer 1
*Click here to know more about derivation substitution logic in transformer
*Click here to know unwanted dmp files in datastage client
*Click here to know about datastage client patch installation
*Click here to know teradata connector stage properties in details
*Click here to know more "verb-unlock-is-not-in-your VOC file"
*Click here to know CC_MSG_LEVEL env. variable for Connector Log Handling
*Click here to Know About Horizontal Pivoting step by step
* Click here to know about Vertical Pivoting step by step
* Click here to know datastage best performance monitoring tools/methods

*Click here to know Best 36 Parallel Datastage Interview Questions and Answers V1.4

*Click here to know 50 Mostly Asked Datastage Interview Questions and Answers V1.5

*Click here to know about Sequential File Best Performance Settings/Tips
*Click here to know Best 36 Datastage Interview Questions and Answers for beginners
*Click here to know Unix File Permission in Details- chmod Calculator
*Click here to know Environment Variables Use For Performance Tuning
*Click here to learn Oracle SQL Query Writing Within 2 Hours

*Click here to know DSAdmin Command to Create/Delete/View Datastage Project 

*Click here to know istool commands for Export/Import datastage project

1. Datastage Related

Datastage Performance Tuning Related
1.Click here to know datastage performance tuning v1.1
2.Click here to know datastage performance tuning v1.2
3.Click here to know best partitioning methods for good performance
4.Click here to know datastage jobs best practices for good performance
5.Click here to know datastage parallel processing partition techniques
6.Click here to know data partitioning and collecting methods in details
7.Click here to know Environment Variables Use For Performance Tuning
8.Click here to know datastage best performance monitoring tools/methods 


Datastage Error and Warnings
1.Click here to know about datastage most common errors and warnings
2.Click here to know about fifo RT_SCTEMP Error
3. Click here to know about datastage errors and warnings - part 2


Datastage Stages and Logic Implementations
1.Click here to know about transformer looping functions for pivoting the data
2.Click here to know about surrogate key generator implementation
3.Click here to know about transformer looping concept 
4.Click here to know about slowly changing Dimention(SCD) implemenation
5.Click here to know use of stages in datastage

6.Click Here to know Orchadmin Command uses and details

7.Click here to know about Parameter Set and Value Set

8.Click here to know removing multiple segments from XML file using DOS Command 
9.Click here to know about Sequential File Best Performance Settings/Tips

Datastage Version Differences
1.Click here to know datastage 9.1 new features and changes
2.Click here to know about datastage 8.5 new features
3.Click here to know about datastage 8.5,8.7 and 9.1 Changes 


Datastage Architecture and DS Engine Command Related
1.Click here to know about Datastage 8.x/9.x Architecture
2.Click here to know about datastage job run time architecture Section Leader 
3.Click here to know the datastage engine start and stop (DS 8.x/9.x Series)
4.Click here to know datastage jobs deletion using command 
5.Click here to know the Unlocking of datastage jobs and deletion 

6.Click here to know DSAdmin Command to Create/Delete/View Datastage Project 

7.Click here to know istool commands for Export/Import datastage project

Datastage Instalations Related
1.Click here to know datastage 8.x/9.x server installation on windows machine   



2. UNIX Related

Unix Scripting Related Problem and Solutions:

Please refer below mentioned links for Unix Related Commands and Scripting related posts

1.Click here to know Useful Unix Commands and It's Usage

2.Click here to know some Logic's Of Unix Commands
   

3.Click here to know 15 Best logics of Unix Commands & Implementations
   Above link will give you details about Unix head,tail,sed,cat,wc & more commands

4.Click here to know 13 Best logics of Unix Commands & Implementations
   Above link will give you details about Unix zip,tar,unzip,echo & ps commands

To Be Continued............... 

3.Oracle Related Informations,Problems and Solutions :DK®

This Post will help you to Understand different databases (Oracle,DB2,Teradata, Greenplum,SQL Server) Related informations, Problems with Solutions & Shortcut Tricks..!DK®

1. Click here to learn Oracle SQL Query Writing Within 2 Hours

2.

To Be Continued...............

4.DW&BI Interview Related

ETL Interview Related Questions and Answers :

Please click on below mentioned links for Answers..!

Datastage Interview Questions and Answers

1.Click here to know Keyless and Keyed Partitioning Methods

2.Click here to know Conductor node, Section Leader and Player

3.Click here to know Datastage Interview Related Questions and Answers V1.1

4.Click here to know Datastage Interview Related Questions and Answers V1.2

5.Click here to know Datastage Interview Related Questions and Answers V1.3

6.Click here to know Best 36 Parallel Datastage Interview Questions and Answers V1.4

7.Click here to know 50 Mostly Asked Datastage Interview Questions and Answers V1.5

Datawarehousing Concepts Questions and Answers

1.Click here to know datawarehousing concepts Question ans Answers

Unix Related Interview Questions and Answers

1.Click here to know about general Unix Command Usage

2.Click here to know Best 15 Unix Interview Questions and Answers

  

To Be Continued............... 

5. DW&BI Certification Related

DW&BI Softwares Certifications Related Information & Certification  Exam Dumps

Datastage Certifications Related Information : 

1. Datastage 8.0 (000-418) Related informations and Details

2. Datastage 8.5 (000-421) Related Informations and Details

3. Datastage 9.1 (000-303) Related Informations and Details

**Click here for Online Registration For IBM Datastage Certifications

Click on below Mentioned Links for Certification Exams Dumps for 99.9999% Success ...!

1. Click Here for Datastage v8.0 Certification Exam Dump

2. Click Here for Datastage v8.5 Certification Exam Dump

3. Awaiting further dumps..