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 46701.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 7718How 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?
4458Converting 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 11313How 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 10777Post New HP Interview Questions
Mention the difference between Data Mining and Machine learning?
What is the purpose of the segment register?
What is the difference between drop and truncate commands?
What is the ?$? as an authorization value?
What is the naming convention in yii framework? Explain
How to know vacuum in vacuum cylinder of breaker in working condition
Why do I get error message "could not load type" whenever I browse to my asp.net web site?
Zenq interview questions for manual testing
Write a function in R language to replace the missing value in a vector with the mean of that vector?
How to convert document list to document? If document list contain documents and documents contain strings field. How to convert?
Difference between import wizard vs dataloader?
write the test case for Bulb & Mobile phone
Does order by actually change the order of the data in the tables or does it just change the output?
What is a screen layout? : fi- general ledger master data
Compare the features of AngularJS and jQuery?