Data Stage Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Stage Interview Questions

Questions Answers Views Company eMail

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

Wipro,

2171

how do u reduce warnings

CGI,

1 7959

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2928

How do you get log info into a file?

1 3313

Different ways a project can be moved to production ?...example â€¦.export-import and Version control.

2391

What is Cleanup Resources and when do you use it?

2 8350

How to remove blank spaces from data?

3 12978

how will u design file watch jobs?

2 7361

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

2750

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

5 10510

if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????

3 8846

i want job aborted after some records are loaded into output by using only sequential stage and dataset

IBM,

1 6340

how to get the unique records on multiple columns by using sequential file stage only

3 9938

iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..

Wipro,

4 8228

HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com

FIS,

5 10752

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

How do you start developing a datastage project?

1059

What are routines in datastage?

1269

What are the important features of datastage?

1051

What is the difference between account and directory options ?

1114

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

1098

Nls stands for what in datastage?

1145

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5046

Differentiate between datastage and datastage tx?

1005

What is staging variable?

1029

What are the types of hashed files in data stage

1059

What are the functionalities of link partitioner and link collector?

952

What are the stages in datastage?

1033

How do you reject records in a transformer?

1061

What all are the different way to run a job?

1030

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

1225

For More Un-Answered { Data Stage } Questions Click Here