Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8914 Views
- Wipro, I also Faced
- E-Mail Answers
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?
what is the use of skid in reporting?
How to convert RGB Value to Hexadecimal values in datastage?
Name the different sorting methods in datastage.
What is the difference between passive stage and active stage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
Lookup constraints
What are the types of containers and how to create them?
What is the sortmerge collector?
options available in sequence job to run,validate?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How to find value from a column in a dataset?
What is the difference between the local container and shared container?
what are the errors,warnings in datastage
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
