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
- 18429 Views
- CSC, iNautix, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is flashback table ? Advance thanks
explain about unit testing? in real time?
How to improve the performance of a session using sorter transformation?
What is informatica?
Define the various join types of joiner transformation?
How do we call shell scripts from informatica?
What are the types of lookup transformation?
Explain the different dimensions.
How to update a particular record in target with out running whole workflow?
What do you mean by blocking transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is the use of target designer?
How to delete duplicate row using informatica?
What is the difference between informatics 7x and 8x and what is latest version?
Tell me about Propagate functions in informatica
