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
- 9166 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
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What are the different kinds of views available in a datastage director?
Enlist various types of routines in datastage.
What are the different common services in datastage?
What is ibm datastage flow designer?
What are the different plug-ins stages used in your projects?
How can you write parallel routines in datastage PX?
What are the features of datastage flow designer?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Explain datastage architecture?
How to convert RGB Value to Hexadecimal values in datastage?
Differentiate between datastage and datastage tx?
