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 |
how to get the first row without using rank t/r?
What are the differences between joiner transformation and source qualifier transformation?
What are the designer tools for creating tranformations?
what is mapping parameter and mapping variables
What is the functionality of update strategy?
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
design of staging area?
How can you access the remote source into your session?
what is lookupoverriding?
What is mapplet and a reusable transformation?
What is dynamic cache?
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,