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
- 17336 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
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Informatica Checkpoints
can you please explain me pre session and post session options?
What is a repository? And how to add it in an informatica client?
Why is sorter an active transformation?
What are the differences between oltp and olap?
Under which circumstances, informatica server creates reject files?
difference between repository database and repository service?
How to do unit testing in informatica?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
Explain what are the different versions of informatica?
How union transformation is used?
How to create a non-reusable instance of reusable transformations?
Explain your project of banking domian.
Explain informatica architecture - version 8 / 9
