Interested to Buy Any Domain ? << Click Here >> for more details...
Hi All,
I have three question.
1) How to remove the header and footer in a flat file in
informatica?
2)How to load the first and last record of flat file into
the target?
3)I have a Input and Output table.
Input
Name Salaray Month
A 100 Jan
A 200 Feb
A 300 March
B 400 April
B 500 May
B 600 June
Output
Name Salaray Month
A 100 Jan
A 300 Feb
A 600 March
B 400 April
B 900 May
B 1500 June
How to implement and get the ouput as mentioned above.
If Possible kindly provide the SQL query also.
Kindly any one help to implement this concept.
Thanks,
Pradeep
- 3 Answers
- 18389 Views
- CSC, iNautix, I also Faced
- E-Mail Answers
Answer Posted / babu
Hi Pradeep,
SQL Query for your requirement
============================
SELECT Name,SUM(salary) OVER(PARTITION BY Name ORDER BY Name,salary) AS Salary, MONTH FROM SAMPLE
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Explain load alternative records / rows into multiple targets - informatica
What is a joiner transformation?
What does command task mean?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What are session parameters ? How do you set them?
Define the various join types of joiner transformation?
What is data movement mode in Informatica and difference between them?
What are the types of data warehouses?
What is olap (on-line analytical processing?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is decode in informatica?
What do you mean by enterprise data warehousing?
What are the different types of transformation available in informatica.
What are the types of lookup transformation?
Explain the pipeline partition with real time example?
