can you avoid static cache in the lookup transformation? I mean can you
Answer / isha
Yes.
Uncheck the 'lookup cache enabled" option. It will become un-cached lookup and will fire query on DB directly... It is not a good idea at all. Cache always increases speed of execution.
| Is This Answer Correct ? | 0 Yes | 0 No |
how do u move the code from development to production?
Explain Dataware house architecture .how data flow from intial to end?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are 2 modes of data movement in Informatica Server?
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
How to create or import flat file definition in to the warehouse designer?
what r the values tht r passed between informatics server and stored procedure?
Please let me know how to make encryption and decryption with example?
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer