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,

2284

how do u reduce warnings

CGI,

1 8138

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

3018

How do you get log info into a file?

1 3481

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

2499

What is Cleanup Resources and when do you use it?

2 8587

How to remove blank spaces from data?

3 13333

how will u design file watch jobs?

2 7612

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

2852

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 10865

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 9110

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

IBM,

1 6572

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

3 10271

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 8606

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 11156

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is data partitioning?

1266

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

5189

How to implement complex jobs in data stage?

1157

What is the different type of jobs in datastage?

1024

Difference between server jobs & parallel jobs?

1129

What are the primary usages of datastage tool?

1128

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

2776

Difference between data warehousing and olap?

1141

project Steps,hits, Project level HArd things,Solved methods?

2182

client know skid info?

2134

Why do we use link partitioner and link collector in datastage?

1186

What are the benefits of datastage?

1301

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

1347

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2099

Define project in datastage?

1148

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