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


Please Help Members By Posting Answers For Below Questions

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1599


Briefly define a session task?

674


Define pmcmd command?

714


What is the benefit of session partitioning?

696


What is dynamic cache?

695






How you prepared reports for OLAP?

1246


To import the flat file definition into the designer where should the flat file be placed?

747


What is rank transform?

675


What is persistent lookup cache?

685


What is confirmed fact in dataware housing?

5910


Sequence generator, when you move from develoment to production how will you reset

1525


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2179


What is the use of transformation?

655


On which transformations you created partitions in your project?

866


What is a difference between complete, stop and abort?

739