country, state 2 tables r there. in table 1 have cid,cname table2 have sid,snam

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?

Question Posted / simha

3 Answers
9072 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based ..

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

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based ..

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

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based ..

Answer / simha

same scenario i want datastage side?

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Data Stage Interview Questions

Is there any possibility to generate alphanumeric surrogate key?

3 Answers ABC, IBM,

Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.

2 Answers IBM,

by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?

1 Answers

What is active and passive stage?

0 Answers

How to move data set from one server to other?what are the steps to follow to do this?

2 Answers

i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc Ple help any one?

4 Answers SLK Software,

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

8 Answers Cognizant, HCL, TIAA CREF,

How many nodes supported by a one cpu in parallel jobs?

3 Answers IBM,

Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?

3 Answers IBM, TCS,

If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

5 Answers Infotech,

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

0 Answers

how to remove duplicates in transformer stage by using stage variables?one example?

6 Answers Syntel, TCS,

For more Data Stage Interview Questions Click Here