Hi All, I have three question. 1) How to remove the header and footer in a

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 / pradeep

3 Answers
16985 Views
CSC, iNautix, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hi All, I have three question. 1) How to remove the header and footer in a flat file in info..

Answer / sridhar k

hi pradeep,

1) to remove header go to session->mapping->source file->set file properties->advanced->no of initial rows escaped(1)

footer-> instr(col,'footer')=0

2)lot of ways u can achieve here giving one solution

SQ->RANKT/R(SELECT TOP NO OF RANKS 1) ->TGT
SQ->RANKT/R(SELECT BOTTOM NO OF RANKS 1)->TGT

Is This Answer Correct ?

8 Yes

3 No

Hi All, I have three question. 1) How to remove the header and footer in a flat file in info..

Answer / babu

Hi Pradeep,

These are columns in
Exp Trans:

name (input & output)
salary (input)
month (input & output)
V_Sal: if(old_name=name,v_Sal+sal,sal) (Variabkle port)
Olad_name=name (Variable port)
o_sal=V_Sal (output port)

connect only name,o_sal,month columns to the target
it gives you what u r expecting. get the

Is This Answer Correct ?

7 Yes

2 No

Hi All, I have three question. 1) How to remove the header and footer in a flat file in info..

Answer / 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