write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
1 46021.In VB Script 100 lines Script. How can check the Syntax errors? 2. Write a VB Script for X = India/Srilanka/Australia/England/South Africa.I need the Output Country wise? [ 1st Msgbox India , 2nd Msgbox Srilanka] ---- 3. How can Choose these test cases to be automated?
5 7573How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?
4405Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
8 11089How is the 90 percentile calculated? Say I am having total 2000 transactions pumped to the system and I have 1800 passed and 200 failed. So the 90 pertile is considered from the Passed transactions or (passed+failed) transactions?
4 10618Post New HP Interview Questions
What is the use of index server?
what are the accounting ratios
What are the drawbacks of Apache Spark?
What does kernel panic mean?
Explain the function and working of dashboard module ?
What is a static member?
What is Page Authority?
what is Huvec cell number ?
Explain types of workbook protection in excel.
How Session outproc in Sqlserver stored?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Write a function to perform the substraction of two numbers. Eg: char N1="123", N2="478", N3=-355(N1-N2).
Can anyone give me an example of realtime start script in the graph?
Explain about package diagram?
What is a shared lock?