Interested to Buy Any Domain ? << Click Here >> for more details...
How to add source flat file header into target file?
- 3 Answers
- 9341 Views
- Logica CMG, I also Faced
- E-Mail Answers
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 |
What is workflow monitor?
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
What does reusable transformation mean?
What are the challenges you have faced in your project?
When do you use sql override in a lookup transformation?
Filter transformation in the condition one of the data is NULL would the record be dropped.
how to import multiple flat files in to single target where there is no common column in the flat files
In a sequential batch can u run the session if previous session fails?
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
Design a mapping to load a target table with the following values from the above source?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
can you use flat file for repository?why?
Teradata 
