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?
- 3 Answers
- 9235 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
What are the unit test cases you used in your project?
What is datastage engine?
which cache supports connected & un connected Lookup
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?
how to identifie,is it innerjoin,leftouter join in lookup?
Can you filter data in hashed file?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?
Name the command line functions to import and export the DS jobs?
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Teradata 
