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,

2233

how do u reduce warnings

CGI,

1 8041

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

2969

How do you get log info into a file?

1 3414

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

2446

What is Cleanup Resources and when do you use it?

2 8467

How to remove blank spaces from data?

3 13186

how will u design file watch jobs?

2 7504

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

2800

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 10709

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 8983

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

IBM,

1 6470

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

3 10115

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 8428

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 11000

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

932

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

1390

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1008

What is use Array size in datastage

1779

What is process model?

1976

Can you explain repository tables in datastage?

1408

What is the project in datastage?

1114

how many rows sorted in sort stage by default in server jobs

3997

what is the use of skid in reporting?

2381

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

1153

Describe stream connector?

1307

Name the different types of Lookups in Datastage?

1259

Describe link sort?

1013

What could be a data source system?

1009

How can we improve performance of data stage jobs?

1017

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