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
- 8356 Views
- Accenture, I also Faced
- E-Mail Answers
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 different between the data warehouse and data mart?
Implementation methodology
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Tell me about Propagate functions in informatica
wat are deployement groups in informatica, how it will be used for developers
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How to create or import flat file definition in to the warehouse designer?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Explain the difference between mapping parameter and mapping variable?
Different qualification between a related rotate toward the sky and isolates look upward?
What is powercenter on grid?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Whats the difference between informatica powercenter server, repositoryserver and repository?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
