How can a Lookup with Dynamic Cache be replaced in a
mapping? Explain.
Answers were Sorted based on User's Feedback
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 |
Answer / qamar
I suppose the answer to this question is by using Joiner
transformation.
Is This Answer Correct ? | 1 Yes | 0 No |
How to do the error handling of if ur source is flatfiles?
Design a mapping to load a target table with the following values from the above source?
What are the types of data that passes between informatica server and stored procedure?
How to send duplicates to one target and unique rows to one target?target is empty
What is the difference between view and materialised view?
How to prepared lld.can any one tell me detailed explanetion.
What are connected or unconnected transformations?
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
What are the limitations of joiner transformation?
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
In a sequential batch can you run the session if previous session fails?
What is operational data source (ODS)?