Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

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

in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh

1 Answers   IBM,

i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?

5 Answers   HSBC,

Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance

2 Answers   IBM,

when we will use connected Lookup & Unconnected Lookup

3 Answers   Wipro,

what is the use of invokation id

2 Answers   IBM,

CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....

2 Answers   Wipro,

CHANGE CAPTURE

0 Answers   CTS,

What is the function in Transformer stage can act as Rank Function in oracle

1 Answers   Reliance,

i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.

4 Answers   Wipro,

how can we extract data with out having any common column

7 Answers   IBM, Switch2iTech,

what is the diff between sequential file and fileset stages?

3 Answers  

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers   Infosys,

For more Data Stage Interview Questions Click Here
Categories