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?

2967

How do you get log info into a file?

1 3412

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 8466

How to remove blank spaces from data?

3 13183

how will u design file watch jobs?

2 7501

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 10705

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 6468

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

3 10113

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 8427

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 10997

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is ibm datastage?

970

Notification Activity

1398

Differentiate between odbc and drs stage?

1050

What a datastage macro?

1059

Lookup constraints

1254

How many areas for files does datastage have?

1152

Can you explain repository tables in datastage?

1407

What are the types of views in datastage director?

1772

What is a ds designer?

1070

What are datastage sequences?

1118

Nls stands for what in datastage?

1189

What is difference between join, merge and lookup stage?

1095

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2812

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

2277

What is the difference between hashfile and sequential file?

1259

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