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 |
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?
1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override
Explain direct and indirect flat file loading (source file type) - informatica
disable caching in a lookup transformation?
How many repositories can we create in Informatica?
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
what are the differences between powercenter 8.1 and powercenter 8.5?
What are the conditions needed to improve the performance of informatica aggregator transformation?
1 lac of flat fles in source how to load target at a time?
write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
What are data-driven sessions?