How to add source flat file header into target file?

Answers were Sorted based on User's Feedback



How to add source flat file header into target file?..

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

How to add source flat file header into target file?..

Answer / sehaj

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

How to add source flat file header into target file?..

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

Post New Answer

More Informatica Interview Questions

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,


My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

2 Answers  


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  


Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,


What is domain and gateway node?

0 Answers  






What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,


I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers   Amdocs,


whatis the default data driven operation in informatica

2 Answers  


What is Factless fact table ???

12 Answers   Satyam, Tech Mahindra,


Explain the shared cache and re-cache?

0 Answers  


i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

5 Answers   L&T,


what is the complex transformation you used in informatica

0 Answers   TCS,


Categories