from Source 100 rows are coming, on target there are 5 m
rows which options is better to match data
1. Joiner
2 No cache
3. Static
4. Dynamic
Answer Posted / vijaykumar
Answer 7# is wrong because here we have only 1 source. It is
correct in case of 2 sources.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the maplet?
How would you join a node to the already existing domain?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is difference between a gateway node and worker node?
What is aggregate cache in aggregator transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
How many transformations can be used in mapplets.
How to create Target definition for flat files?
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.
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How to do unit testing in informatica? How to load data in informatica ?
How identifying bottlenecks in various components of informatica and resolving them?
Define the various join types of joiner transformation?
What is native users?
How to create or import flat file definition in to the warehouse designer?