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 tasks that source qualifier perform?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Enlist some properties of sessions.
What is target designer and target load order?
What are the main issues while working with flat files as source and as targets ?
What is complex mapping?
Differences between version 7.x and 8.x.
What are the features of complex mapping?
What is the benefit of partitioning a session?
If informatica has its scheduler why using third party scheduler?
What are the steps involved in the migration from older version to newer version of Informatica Server?
How do you load unique records into one target table and duplicate records into a different target table?
what is SDLC way of code development?
How to do unit testing in informatica? How to load data in informatica ?
Which transformation should we use to normalise the COBOL and relational sources?