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
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
How will you display "Mr" for male & "Mrs" for female in target table?
What is the difference between Active and Passive transformation?
Explain the types of transformations?
WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?
1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
4 Answers CompuSoft, EDS, TCS,
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
Normalizer transformation is not involved in Mapplet.. why???
why union is active transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
How we can create indexes after completing the load process?