1.why we need to use unconnected transformation? 2.where we can static chach,dy

1.why we need to use unconnected transformation?
2.where we can static chach,dynamic chach

Question Posted / mohanreddy

4 Answers
13156 Views
Virtusa, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach..

Answer / 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

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach..

Answer / sreenu

Unconnected lkp is used for the performance preps bcz hear
we can return only one port and also it is not participated
in mapping directly in ulkp we can use only static cache.

Static cache: static cache is used in unconnected lkp, once
the data is cached it won’t modified.
Dynamic cache: in connected lkp we can use dynamic lkp. By
the use of dynamic lkp we can capture the changed
data.becage dynamic cache is automatically update the
cached data

Is This Answer Correct ?

4 Yes

0 No

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach..

Answer / satyam

We use an unconnected transformation when we need one
return column from each row and it receives values from:
LKP expression from another transformation.

Is This Answer Correct ?

1 Yes

0 No

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach..

Answer / tanay

1.We use unconnected transformation to use multiple number
of tables or views without physically taking the entity
into mapping.This kind of transformation is also helpful
when single return port is required.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer

More Informatica Interview Questions

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers IBM, Infotech,

What is difference between Mapplet and reusable transformation?

9 Answers Wipro,

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6 Answers IBM,

What is decode in static cache?

0 Answers

select count(1) from emp? what is the o/p?

5 Answers TCS,

what are challenges that you faced in testing? give solution to it?

1 Answers

What is the difference between informatica 8.x and 9.x

1 Answers Wipro,

Explain dynamic target flat file name generation in informatica

0 Answers Informatica,

I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..