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
18266 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

Explain the different lookup methods used in informatica?

975

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1980

What is workflow? What are the components of the workflow manager?

1070

How many numbers of sessions can one group in batches?

1016

define galaxy repository in informatica

2158

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1205

What is Session and Batches?

1042

What is meant by target load plan?

916

State the differences between sql override and lookup override?

1114

How can we remove the duplicates from flat file source?

950

What is the procedure for creating independent data marts from informatica 7.1?

1003

Enlist some properties of sessions.

1024

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2393

As union transformation gives UNION ALL output, how you will get the UNION output?

1042

Where are the source flat files kept before running the session?

1013