can we use bulk loading when we use look in mapping
Answer / sayan
yes we can use bulk load if we are using static lookup.
condition: 1. we are not using a dynamic lookup on the target table. 2. There is no duplicate in the record in the data.
Is This Answer Correct ? | 0 Yes | 0 No |
What are the main issues while working with flat files as source and as targets ?
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
Could any one to tell How to use the Oracle Analytic functions in Informatica?
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
What is data transformation manager process?
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
Can you create a flatfile target
How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.
Where do we use mapping variables in informatica?
Explain about Informatica server process that how it works relates to mapping variables?