Informatica 10.2 Dynamic Lookup with Example

Informatica 10 2 Dynamic Lookup/Cache with Example

[@Kiran_badvel]

Sir your explanation is good thanks for posting this video

[@sureshetltrainer]

Keep watching.....

[@shyamkumar4107]

You said that dynamic cache concept is used if we encounter multiple records on one id, but my question is we can delete duplicate records in many ways. why should we use this dynamic cache concept? and one more question is in dynamic lookup, we are already comparing values with the associated port, then why we are giving in condition tab again?

[@Adikes_InfoTech]

The first reason for using dynamic lookup to improve the performance of the job, if you use other ways to remove duplicates the performance will degrade. With condition only the lookup will work.

[@ngalgj7088]

Are we using this Dynamic look up concept for Scd type 1 ??

[@sureshetltrainer]

Yes correct

[@pidigovulanaresh9234]

Hi Suresh nice explanation thank you,have u uploaded versioning video?

[@sureshetltrainer]

I think it is Already there

[@andychatter]

Hiiii Sir, When you can decide that you need to choose dynamic cache? Static cache works by default when you used lookup table but how can you be sure that you have to enable dynamic cache

[@sureshetltrainer]

If your source is having duplicates then you may go with dynamic lookup

[@ernestbal633]

Thanks bro for sharing

[@ngalgj7088]

Very good sir. Thank you

[@sureshetltrainer]

Keep watching

[@praveen9muni]

I have table in that table only one column and it contain A B C D E These 5 rows convert into 5 columns through informatica, please explain this

[@tharunkumar3442]

sql overwride query : select max(case r when 1 then nvl(f1,0) end ) c1 , max(case r when 2 then nvl(f1,0) end ) c2 , max(case r when 3 then nvl(f1,0) end ) c3 , max(case r when 4 then nvl(f1,0) end ) c4 (select f1 ,rownum r from src); it will work

[@junedkhan-ge5mi]

ITS WORK AS SCD1,2 IS THERE IS ANY OTHER USE OF DYNAMIC CACHE?

[@sureshetltrainer]

It works as SCD 1 not scd2

[@junedkhan-ge5mi]

@@sureshetltrainer yess I had try when attempting to insert duplicate into target wf fail due to insert into dynamic cache why lookup error

[@sivabala4128]

Nice explanation sir thank you sir

[@sureshetltrainer]

Thank you... please keep watching

[@sudhakarreddy191]

Any offline classes available?

[@sureshetltrainer]

Only online

[@ernestbal633]

How much bro?

[@sureshetltrainer]

@@ernestbal633 call me on 9060099974

[@anilkumarakc1046]

Good explanation

[@sureshetltrainer]

Keep watching

[@priyam4781]

How to create sequence using lookup

[@ernestbal633]

How much online training bro?

[@sureshetltrainer]

you can call to my no 9060099974 for more info.

[@mudashivaprasad2329]

Hi Suresh can you please provide all interview questions on ETL TESTING..

[@sureshetltrainer]

ETL testing i don't have but let me check

[@anilkumarakc1046]

Please continue session

[@sureshetltrainer]

Still it is uploading please wait for some time...session completed.

[@anilkumarakc1046]

Difference between 9.x and 10.x informatica powercenter developer-please made the video

[@sureshetltrainer]

sure will do