How can a Lookup with Dynamic Cache be replaced in a
mapping? Explain.

Answers were Sorted based on User's Feedback



How can a Lookup with Dynamic Cache be replaced in a mapping? Explain...

Answer / abhishek.x.upadhyay

A lookup with Dynamic cache can be replaced by an SQL
override query in the transformation itself which will run
each time there is load of data during the run of the
Workflow.

Is This Answer Correct ?    4 Yes 2 No

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain...

Answer / qamar

I suppose the answer to this question is by using Joiner
transformation.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

How to do the error handling of if ur source is flatfiles?

0 Answers  


Design a mapping to load a target table with the following values from the above source?

0 Answers   Informatica,


What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,


How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,


What is the difference between view and materialised view?

6 Answers  






How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,


What are connected or unconnected transformations?

0 Answers   Informatica,


scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  


What are the limitations of joiner transformation?

0 Answers   Informatica,


what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 Answers   Accenture, CSC,


In a sequential batch can you run the session if previous session fails?

4 Answers  


What is operational data source (ODS)?

7 Answers  


Categories