Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1108


In warehouses how many schemas are there?

1061


How can you generate reports in informatica?

1010


Target increases every day even though no new record was inserted

1565


What is powercenter on grid?

1168


What is rank index in rank transformation?

1058


Do you find any difficulty while working with flat files as source and target?

1085


How many input parameters can exist in an unconnected lookup?

1534


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2058


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.

1683


What are the components of workflow manager?

1078


On which transformations you created partitions in your project?

1326


What are the different options available for update strategy?

994


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?

1956


What is the need of etl tools?

1103