During the running session, output files are created by informatica server. Enlist few of them.
Answer / Vivek Kumar Tripathi
Informaticas output files include log files (e.g., *.log), work files (e.g., *.wrk), stage files (e.g., *.stg), and result files (e.g., *.csv, *.txt).
| Is This Answer Correct ? | 0 Yes | 0 No |
What is router transformation
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??
performance wise which one is better in joiner and lookup transformation
in what type of scenario bulk loading and normal loading we use?
how to load duplicate row in a target
What is the difference between Normal load and Bulk load?
how many session run unix environment what command using ?
What is dimensional table? Explain the different dimensions.
How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation