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
8918 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

what is the use of invokation id

2 Answers IBM,

i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?

4 Answers L&T,

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

1 Answers TCS,

Explain Quality stage?

0 Answers

what is the use of materialized view?

0 Answers CTS,

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks

5 Answers Cap Gemini,

Define data aggregation?

0 Answers

Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?

3 Answers IBM,

hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha

6 Answers CTS,

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..

1 Answers

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

1 Answers IBM,

How to Convert the columns into rows?

2 Answers

For more Data Stage Interview Questions Click Here