Data Stage Interview Questions
Questions Answers Views Company eMail

Explain datastage architecture?

820

What are iconv and oconv?

779

What are the different plug-ins stages used in your projects?

630

How do you generate sequence number in datastage?

628

Define data aggregation?

677

What are the difference types of stages?

627

How do you schedule or monitoring the job?

676

What is staging variable?

626

Which algorithm you used for your hashfile?

695

What is apt_config in datastage?

708

What are the types of jobs we have in datastage?

678

How can we improve the performance in datastage?

656

What are stage variables?

641

What are orabulk and bcp stages?

653

What is datastage engine?

733


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the partitioning techniques available in link partitioner?

1761


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

668


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

1672


table actions available in oracle connector?

1099


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1476






What are some different alternative commands associated with "dsjob"?

666


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1705


Why we use surrogate key?

701


What is the importance of the exception activity in datastage?

630


How to implement complex jobs in data stage?

621


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1638


How can one find bugs in job sequence?

793


I have a few records just I want to store data in to targets cycling way how?

1907


How do u convert the columns to rows in datastage?

694


Have you used Unstructured data?

841