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
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
Explain how many types of dimensions are available in informatica?
How to do unit testing in informatica?
Explain lookup transformation source types in informatica
What can we do to improve the performance of informatica aggregator transformation?
what are the deliverables?in your project?
Explain the shared cache and re-cache?
What are some examples of informatica etl programs?
what is degenerated dimension?
Performance tuning( what you did in performance tuning)
how to load rows into fact table in data warehouse
Why do we need informatica?
What do you understand by term role-playing dimension?
what is $$$$?
Explain direct and indirect flat file loading (source file type) - informatica
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?