Data Stage Interview Questions
Questions Answers Views Company eMail

Difference between data warehousing and olap?

641

What is the difference between operational data stage (ods) and data warehouse?

657

What are the types of containers in datastage?

690

Explain entity, attribute and relationship in datastage?

615

Difference between in process and inter process?

683

What are stage variables and constants?

689

What are the components of datastage?

635

What are the differences between datastage and informatica?

560

Explain the importance of surrogate key in data warehousing?

700

How to implement complex jobs in data stage?

602

Difference between server jobs & parallel jobs?

636

Difference between ‘validated ok’ and ‘compiled’ in data stage?

657

What are the functionalities of link collector?

617

What is the purpose of pivot stage?

594

What are the various kinds of the hash file?

649


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the types of hashed files in data stage

630


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

1793


If you want to use the same piece of code in different jobs, how will you achieve it?

625


How many types of stage?

660


What is quality stage?

560






Where do the datastage jobs get stored?

712


Describe the main features of datastage?

645


Can you implement SCD2 using join, transformer and funnel stage?

1068


What is oci?

839


What is the difference between odbc and drs stage?

629


What is the flow of loading data into fact & dimensional tables?

579


what is the difference between == and eq in UNIX shell scripting?

957


What are iconv and oconv?

757


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

2829


How a routine is called in datastage job?

591