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
Answer Posted / triveni
i have one doubt.how to convert source to columns using sourcequalifier. how many columns target we have take.
how to connect source to target
source has 4 columns
target has 2 columns
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sequence generator transformation in informatica?
What is domain in terms of informatica?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How to elaborate tracing level?
Is it possible to create multiple domains on a single Informatica server?
What is a transaction control transformation?
What is the need of etl tools?
Is it possible to define a single node as a Gateway node as well as worker node?
What are active transformations.
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is a difference between complete, stop and abort?
How to join three sources using joiner? Explain though mapping flow.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are multi-group transformations?