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
What will be the approach?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is a joiner transformation and why it is an active one?
What is data movement mode in Informatica and difference between them?
What are the differences between source qualifier and joiner transformation?
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 are the designer tools for creating transformations?
How to use pmcmd utility command?
What is a surrogate key?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Performance tuning in UNIX for informatica mappings?
Where is metadata stored?
What are the popular informatica products?