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?
- 1 Answers
- 4992 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer / priyank
select the option "append if exists" in the session
properties.
| Is This Answer Correct ? | 3 Yes | 0 No |
How might one distinguish in the case of mapping is right or not without associating session?
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
What is an expression transformation?
How do you do error handling in Informatica?
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
what are the perameter and variable?
What is expression transformation?
What could be the possible resons of locks by user?
Which will beter perform IIf or decode?
How we can confirm all mappings in the repository simultaneously?
What are the new features of informatica 7.1?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
Teradata 
