In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
Answer Posted / joe
s...rank1 (for header)-top option..........Target1
.
.....Aggregator (Count(lastcolumn))........Target2
.
....rank2(for footer)-bottom option........Target3
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
What are the settings that you use to configure the joiner transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Explain why we use partitioning the session in informatica?
Explain constraint based loading in informatica
What are the features of complex mapping?
What is a passive transformation?
Can u generate reports in Informatica?
What are the new features of informatica 9.x at the developer level?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
where to store informatica rejected data? How to extract the informatica rejected data?
What is Index Caches size?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Mention a few design and development best practices for informatica?
In development project what is the process to follow for an etl developer from day1
Describe expression transformation?