how we can add header and footer to flat files?
Answers were Sorted based on User's Feedback
Answer / sidhu
in session properties,
select mapping tab then
select target properties
there header and footer command option
there u give
echo header in header option
and echo footer in footer option
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / mukesh kumar
go to session edit>>>>mapping tab>>>>>>>selct
source>>>>>>in header command option and footer command
option type the command
| Is This Answer Correct ? | 7 Yes | 4 No |
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
how many data models u have done in informatica project?
Which transformation should we use to normalise the COBOL and relational sources?
what is difference between mapping and mapplet ?
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
in which situations do u go for snowflake schema ?
What are the guidelines to be followed while using union transformation?
What are the types of error logs available in Informatica?
what are the differences between powercenter 8.1 and powercenter 8.5?
what is the size of ur database(like oracle)
Difference between Target-based loading and constraint-based loading?
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help