when we create source as oracle and target as flat file, how
can i specify first row as column in flat file?
Answer Posted / guest
In case of target as a flat file, the header names will be
defined during the target definition. The Header names can
be specified using the option called 'Load Header' Option
in Mapping tab of Session. There are three options 1. for
no headers, 2. header from target definition and 3. Load
from Command. based on these we can load the header names
accordingly.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
where to store informatica rejected data?
How can we create index after completion of load process?
What is a joiner transformation?
what is SDLC way of code development?
Write the unconnected lookup syntax?
What is update strategy transform?
How can we use batches?
What is the function of aggregator transformation?
What is status code in informatica?
Which are the different editions of informatica powercenter that are available?
To import the flat file definition into the designer where should the flat file be placed?
What is the difference between a connected look up and unconnected lookup?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Differentiate between reusable transformation and mapplet.
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.