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
- 18570 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
Clarify the aggregator change?
What are different types of transformations available in informatica?
What is enterprise data warehousing?
What do mean by local and global repository?
Separate from an archive server and a powerhouse?
What are the new features of informatica 9.x in developer level?
What are the types of data warehouses?
What is flashback table ? Advance thanks
can we override a native sql query within informatica? How do we do it?
what is the difference between informatica6.1 and infomatica7.1
Target increases every day even though no new record was inserted
Difference between Data and Index Caches?
Describe the impact of several join conditions and join order in a joiner transformation?
Explain sessions?
tell me the rules and responsblites in our project(my project is development)
