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 |
What is meant by LDAP users?
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
How can we get multiple output values using an unconnected lookup transformation?
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?
whatis the default data driven operation in informatica
What is ThroughPut in Informatica, How it works, Where I can find this option to check ?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
What are active transformations? Name them.
How many ways are there to do 'remove duplicate records in informatica'?
what is meant by data driven.. in which scenario we use that..?