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
- 3 Answers
- 17334 Views
- CSC, iNautix, I also Faced
- E-Mail Answers
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 |
Can u generate reports in Informatica?
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
What is a sequence generator transformation?
In informatics server which files are created during the session rums?
how can we use sorter transformation in joins?
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
what is the size of u r project? and what is the size of source file?
Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
how many session run unix environment what command using ?
Teradata 
