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

Slowly changing dimensions, types and where will you use them

1767

Can u generate reports in Informatica?

1143

What do think which one is the better joiner or look up?

1242

Explain load alternative records / rows into multiple targets - informatica

1203

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1141

What are the data movement modes in informatica?

1208

What is the difference between a connected look up and unconnected lookup?

1000

Different sorts of metadata that stores in the storage facility?

1069

What are the new features of informatica 9.x developer?

1026

r u done any partitions in ur project?

1862

What is sequence generator transformation in informatica?

1122

What is the Rank index port in Rank transformation?

1102

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1957

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?

2310

can you please explain me pre session and post session options?

7670