Interested to Buy Any Domain ? << Click Here >> for more details...
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)
869Source 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
725
Differentiate between validated and Compiled in the Datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is the difference between an operational datastage and a data warehouse?
If you want to use the same piece of code in different jobs, how will you achieve it?
What are datastage sequences?
What are sequencers?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How to Remove Duplicate using SQL?
Define orabulk and bcp stages?
Can you explain players in datastage?
How do u convert the columns to rows in datastage?
What is staging variable?
What are the various kinds of containers available in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
