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?
Answer Posted / 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 |
Post New Answer View All Answers
What are the stages in datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How do you remove duplicate values in datastage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What is the difference between operational data stage (ods) and data warehouse?
Explain Quality stage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are constraints and derivations?
What are the important features of datastage?
What are the components of datastage?
Explain entity, attribute and relationship in datastage?
Define project in datastage?
What is merge stage?
What are the types of jobs we have in datastage?
How do you register plug-ins?