Interested to Buy Any Domain ? << Click Here >> for more details...
write sql query following source table
jan feb mar apr
100 200 300 400
500 600 700 800
900 100 200 300
i want the output format like
month total
jan 1500
feb 900
mar 1200
apr 1500
- 3 Answers
- 8522 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / amitabha mandal
use "Normalizer"
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Enlist some properties of sessions.
What is the fact table?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How to create Target definition for flat files?
How can you validate all mappings in the repository simultaneously?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is workflow? What are the components of the workflow manager?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How to join three sources using joiner?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
