Data Stage Interview Questions

 
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?
12.
Is there any possibility to generate alphanumeric surrogate key?
13.
How to enter a log in auditing table whenever a job get finished?
14.
What is audit table?
15.
How to add zero "0" before record in a field?
16.
How to get the unique records on multiple columns by using sequential file stage only?
17.
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?
18.
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?
19.
How to design file watch jobs?
20.
How to remove blank spaces from data?
21.
What is Cleanup Resources and when do you use it?
22.
How to reduce warnings?