Interested to Buy Any Domain ? << Click Here >> for more details...
if we have input eno 1,2,3,1,2,3 year
2001,2002,2003,2001,2002,2003 and sal
10000,20000,30000,20000,30000,40000
ex-output
eno totsal
1 30000
2 50000
3 70000
- 7 Answers
- 9093 Views
- I also Faced
- E-Mail Answers
Answer Posted / narendra
in source qulifier we override query like this
select eno,sum(sal as totsal)from emp group by eno
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the types of data warehouses?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What are the new features of informatica 9.x in developer level?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain the etl program with few examples.
Mention few advantages of router transformation over filter transformation.
How can we improve session performance in aggregator transformation?
What is the function of look up transformation?
Why do you use Mapping Parameter and mapping variable?
How to generate sequence numbers without using the sequence generator transformation?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Different sorts of metadata that stores in the storage facility?
How to generate or load values in to the target table based on a column value using informatica etl tool.
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How to load the data from a flat file into the target where the source flat file name changes daily?
