Hi Pradeep, SQL Query for your requirement ============================

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

Question Posted / babu

3 Answers
18430 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

Please Help Members By Posting Answers For Below Questions

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1897

What are the differences between oltp and olap?

969

Under what condition selecting sorted input in aggregator may fail the session?

1121

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1773

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7224

What is olap (on-line analytical processing?

1063

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?

2258

Explain sessions and how many types of sessions are there?

1001

How to handle decimal places while importing a flatfile into informatica?

1187

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1044

What is an unconnected transformation?

1079

How can one identify whether mapping is correct or not without connecting session?

1438

r u done any partitions in ur project?

1825

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?

1243

how to load dimension table and fact table. plz tell me the steps.

2091