Data Stage Interview Questions
Questions Answers Views Company eMail

Difference between data warehousing and olap?

716

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

761

What are the types of containers in datastage?

782

Explain entity, attribute and relationship in datastage?

702

Difference between in process and inter process?

754

What are stage variables and constants?

782

What are the components of datastage?

720

What are the differences between datastage and informatica?

654

Explain the importance of surrogate key in data warehousing?

791

How to implement complex jobs in data stage?

712

Difference between server jobs & parallel jobs?

728

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

748

What are the functionalities of link collector?

704

What is the purpose of pivot stage?

678

What are the various kinds of the hash file?

757


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

How do you register plug-ins?

668


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2112


what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

731


How the ipc stage work?

736


Can you explain kafka connector?

852






Differentiate between hash file and sequential file?

646


Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

1748


how do u catch bad rows from OCI stage? And what CLI stands for?

2367


Can you explain players in datastage?

782


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2351


What are the types of containers and how to create them?

617


DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1107


How do you schedule or monitoring the job?

740


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1020


what is repositery?

1376