Interested to Buy Any Domain ? << Click Here >> for more details...
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
- 4 Answers
- 21205 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / krishna
joiner is best because we will make less number of records or dublicate records as master. integration servic create cahce for master table. becaue of that cahce size is small and secarching oricess become easy. in case of lookup its should scane om botom to end it will take more time.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the need of etl tools?
Informatica settings are available in which file?
Global and Local shortcuts. Advantages.
Describe expression transformation?
What are the main issues while working with flat files as source and as targets ?
How do you migrate data from one environment to another?
Define sessions in informatica etl?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How we can create indexes after completing the load process?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is intricate mapping?
What are the differences between joiner transformation and source qualifier transformation?
What are connected or unconnected transformations?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is a rank transform?
