Interview Questions And Answers Forum

Ibraheem

Webmaster

From: Capital

Registered: 2012-03-16

Posts: 23,140

Website

Data Stage Interview Questions And Answers

Data Warehouse :: Data Stage Job Interview Questions and Answers

Data Stage job interview preparation guide. Number of Data Stage frequently asked questions(FAQs) asked in many Data Stage interviews

1 ► Is there any possibility to generate alphanumeric surrogate key?
2 ► How to enter a log in auditing table whenever a job get finished?
3 ► What is audit table?
4 ► How to add zero "0" before record in a field?
5 ► How to get the unique records on multiple columns by using sequential  file stage only?
6 ► 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?
7 ► 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?
8 ► How to design file watch jobs?
9 ► How to remove blank spaces from data?
10 ► What is Cleanup Resources and when do you use it?
11 ► How to reduce warnings?