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

Data Stage Interview Questions
Questions Answers Views Company eMail

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

920

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

781


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the types of hashed files in data stage

1108


What are the types of containers and how to create them?

980


How rejected rows are managed in datastage?

1522


What are the features of datastage flow designer?

1039


What is staging variable?

1095


What are the different options associated with dsjob command?

1441


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3650


How a source file is populated?

1066


What are data elements?

1176


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2505


Difference between sequential file and data set?

1205


Can you explain how could anyone drop the index before loading the data in target in datastage?

1504


Which commands are used to import and export the datastage jobs?

1414


What is the importance of the exception activity in datastage?

1073


how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

808