i have a session which creates a file every time when i runs
the session, but it replaces the first file with second file,i
want to append the second file follwed by first file when i
runs the session,how to achieve this?
Answer / priyank
select the option "append if exists" in the session
properties.
| Is This Answer Correct ? | 3 Yes | 0 No |
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.
If u select groupby port in aggregator what is output and dont select groupby option what is output
How is union transformation utilized?
How will you display "Mr" for male & "Mrs" for female in target table?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is meant by pre and post session shell command?
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
Explain the flow of data in Iinformatica?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
How to recover the standalone session?
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?