what is the diff b/w cached and unchaed look ups
Answer Posted / sujana
if v cache the lukup..IS queries the cache for each row dat
eneters
if v dont cache IS queries the database for each row dat
enters..i.e issues a slect statemnt for each row
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the basic requirements to join two sources in a source qualifier transformation using default join?
In warehouses how many schemas are there?
How can you generate reports in informatica?
Target increases every day even though no new record was inserted
What is powercenter on grid?
What is rank index in rank transformation?
Do you find any difficulty while working with flat files as source and target?
How many input parameters can exist in an unconnected lookup?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are the components of workflow manager?
On which transformations you created partitions in your project?
What are the different options available for update strategy?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is the need of etl tools?