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 can we do to improve the performance of informatica aggregator transformation?
draw informatica architecture 8.6 ?
What you know about transaction control transformation?
How to update a particular record in target with out running whole workflow?
What are the new features of Power Center 5.0?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Where do we use mapping variables in informatica?
Performance tuning( what you did in performance tuning)
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is a stored procedure transformation?
Define filter transformation?
How many numbers of sessions can one group in batches?
list out all the transformations which use cache?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How do you load only null records into target? Explain through mapping flow.