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 |
Is snow flake or star schema used? If star schema means why?
How many mapplets u have created? and what is the logic used
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
what are the differences between powercenter 8.1 and powercenter 8.5?
How to handle decimal places while importing a flatfile into informatica?
I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
How Union Transformation is an Active Trans?
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
disable caching in a lookup transformation?
wht is full process of Information source to target just like stg to productuon and development
what are the unix commands to start the wrk flow ?