when we create source as oracle and target as flat file, how
can i specify first row as column in flat file?
Answer / 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 |
How to generate a single mapping for both the historical and incremental load.
what is constraint based load order
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
What is the sql query overwrite in source qualifier in informatica
I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?
How can you define user defied event?
What is mapplet in informatica?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what are the limitations of pushdown optimization technique ? Advance thanks
I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.