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 |
Explain the code page compatibility?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
WHat all joins are there in Source Qualifier?
What is the meaning of up gradation of repository?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
what is size of u r database?
how to join the 2 different table with different columns in informatica?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What are the reusable transforamtions?
How to join three sources using joiner? Explain though mapping flow.
Explain the use of aggregator cache file?
what is data driven in update strategy transformation?