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?
Answers were Sorted based on User's Feedback
Answer / joe
join these two tables on cid and get all the columns to
output. Then in aggregator stage, count rows with key
collumn cid..Then use filter or transformer to get records
with count> 25
Is This Answer Correct ? | 13 Yes | 0 No |
Answer / manikanta.srinu
select state.cid,country.cname from country inner join
state on country.cid=state.cid group by
state.cid,country.cname having count(state.sname)>25
Is This Answer Correct ? | 7 Yes | 3 No |
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?
hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...
HOW CAN WE SEE THE DATA IN DATASET?
how to call sequential generator in datastage?
What is exact difference between Parallel Jobs and server Jobs..
How many input links can you give to a Transformer stage?
what is mapping lookup
What is difference between 8.1 , 8.5 and 9.1 ?
What is a folder? Difference types of stages?
in aggregator , how can i get the sum in readable format
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,
what is the Difference Between Datastage Server Edition and Parallel Edition?