| Other Data Stage Interview Questions |
|| Asked @
|I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4
ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000
DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH
HIGEST SAL ?
|how to configure databases through datastage
|Hi This is Vijay
How Can u Read the data from sequential file Parall'y?
|CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN
|5) A file contains 10 (1-10) I want trgt like
Trgt 1 trgt 2 trgt 3
1 2 3
4 5 6
7 8 9
|i have source data like
i want output like
|country, state 2 tables r there. in table 1 have cid,cname
table2 have sid,sname,cid. i want based on cid which country's
having more than 25 states i want to display?
|How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?
|how to identifie,is it innerjoin,leftouter join in lookup?
|i have a scenario with i/p as ID,salary with values 1,1000
2,2000 and 3,4000 i need an extra column in the o/p named
amount with values 2000,4000 and NULL. how can i get it?
|How many nodes supported by a one cpu in parallel jobs?
|souce file having the columns like
if first row will be repeat i want the result like this
name company count
krish IBM 1
pooja TCS 1
nandini WIPRO 1
krish IBM 2
pooja TCS 2
|For more Data Stage Interview Questions Click Here |