Global Web Forum

AgentVinod12

Agent Vinod

From: India

Registered: 2012-03-23

Posts: 1,149

Website

Data Stage Interview Questions And Answers

Data Warehouse :: Data Stage Job Interview Questions and Answers

Data Stage frequently Asked Questions in various Data Stage job Interviews by interviewer. Get preparation of Data Stage job interview

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?