1.why we need to use unconnected transformation?
2.where we can static chach,dynamic chach
Answer Posted / rahul
In Lookup transformation;
Unconencted is used when ever u want to call the same
transformation several times and u have one return port.
Use dynamic cache if u want to update the case while
updating the target table itself and static is untouched
with the cache.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
While migrating the data from one environment to another environment how would you manage the connections?
What is powercenter on grid?
Which is the t/r that builts only single cache memory?
What are the tasks that can be performed using sq?
What is the function of look up transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is informatica powercenter repository?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Whats there in global repository
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is dimensional table? Explain the different dimensions.
Is there any way to read the ms excel datas directly into informatica?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you