Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 18263 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 |
What are the settings that you use to configure the joiner transformation?
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
wht is full process of Information source to target just like stg to productuon and development
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
what is DSS?
Explain what are the different types of transformation available in informatica.
What is the fact table?
What is main use of mapplet?
Teradata 
