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

how do u catch bad rows from OCI stage? And what CLI stands for?

0 Answers  

1)Source file contains one record, I want 100 records in target file.

3 Answers  

can a fact table contains textual information

6 Answers   HCL, HCL BSERV, 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,

What are the difference types of stages?

0 Answers  

What are the unit test cases you used in your project?

1 Answers   CSC, HY,

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

2 Answers   Infosys,

What is the purpose of pivot stage?

0 Answers  

what is the use of DSattchJob?DetachJob? where can we find it?

0 Answers   IBM,

Difference between the Sequence and Sequencer in DS?

1 Answers   TCS,

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  

How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

2 Answers   TCS,

For more Data Stage Interview Questions Click Here
Categories