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 |
what is incremental aggregation ,with example?
Explain joiner transformation in informatica
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is a unit Testing?
What is DR strategy for Informatica project?
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
how do u use sequence created in oracle in informatica? Explain with an simple example
What do mean by local and global repository?
how i will stop my workflow after 10 errors
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
Using Expression transformation how to remove duplicate records from a relational source?