How to add source flat file header into target file?
Answers were Sorted based on User's Feedback
Answer / raju potla
When we use target as a flatfile then in the mapping tab of
a session click the flatfile target then we have an header
option , in that select output field names
| Is This Answer Correct ? | 6 Yes | 1 No |
IN 7/8 WE CAN GO TO SERVER SETUP N CHOOSE A PROPERTY FROM THERE WHERE READS AS
"CREATE METADTA FOR FLAT FLIE"
IN 8.6 WE CAN SET ITIN SESSION PROPERTIES...OPEN SESSION PROPERTIS
THEN IN TARGET CHOOSE THE HEADER PROPERTY WHERE V DEFINE THE PATHNAME N ALL FOR THE FLAT FILES.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / venkatanarayana manam
First Open the session which contains source/target as Flat file edit the mapping tab-->properties-->Enable Add Currently Processed Flat File Name Port
If selected, a port specifying currently processed file name will be added to the source widget.
| Is This Answer Correct ? | 0 Yes | 0 No |
How we can create indexes after completing the load process?
How can one identify whether mapping is correct or not without connecting session?
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
How union transformation is used?
how to use incremental load?
how can we perform incremental aggregation?explain with example?
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?
What are the various types of transformation?
why we are using level option in normalizer transformation
Explain lookup transformation is active in informatica
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?