Data Stage Interview Questions
Questions Answers Views Company eMail

Does datastage support slowly changing dimensions ?

659

How many types of hash files are there?

608

Nls stands for what in datastage?

726

Define meta stage?

778

Define orabulk and bcp stages?

674

Define repository tables in datastage?

699

How complex jobs are implemented in datstage to improve performance?

589

Can you explain how could anyone drop the index before loading the data in target in datastage?

889

How a routine is called in datastage job?

603

Explain usage analysis in datastage?

648

What is size of a transaction and an array means in a datastage?

737

How many types of views are there in a datastage director?

832

Why we use surrogate key?

696

Define oconv () and iconv () functions in datastage?

872

Name the third party tools that can be used in datastage?

611


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

1799


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

667


What are constraints and derivations?

644


What are the different options associated with dsjob command?

932


Explain how a source file is populated?

759






Highlight the main features of datastage?

613


What is aggtorec restructure operator?

722


How the ipc stage work?

668


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

649


What are the functionalities of link partitioner?

614


What steps should be taken to improve Datastage jobs?

635


How you can fix the truncated data error in datastage?

1190


How we can covert server job to a parallel job?

593


how to sort two columns in single job in datastage.

2529


What is the command line function to import and export the ds jobs?

679