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

how to get the first row without using rank t/r?

7 Answers   iGate,


What are the differences between joiner transformation and source qualifier transformation?

0 Answers   Informatica,


What are the designer tools for creating tranformations?

1 Answers   Informatica,


what is mapping parameter and mapping variables

1 Answers   BirlaSoft,


What is the functionality of update strategy?

2 Answers  


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  


design of staging area?

0 Answers  


How can you access the remote source into your session?

1 Answers  


what is lookupoverriding?

1 Answers  


What is mapplet and a reusable transformation?

2 Answers  


What is dynamic cache?

0 Answers  


I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,


Categories