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
- 9062 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
Terminate Activity
What is the difference between odbc and drs stage?
What is job control?
What is the difference between informatica and datastage?
What is the method of removing duplicates, without the remove duplicate stage?
How to read multiple files using a single datastage job if files have the same metadata?
Difference between server jobs & parallel jobs?
CHANGE CAPTURE
What is a merge?
Why fact table is in normal form?
What is a merge in datastage?
What are the differences between datastage and informatica?
in oracle target stage when we use load option and when we use upsert option?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
I have a few records just I want to store data in to targets cycling way how?
