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 |
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
What happens if we dont select data driven option?
What is an aggregator transformation?
How can we get multiple output values using an unconnected lookup transformation?
what is the significance of newlookup port in dynamic look up
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
what is diff between grep and find
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
how can we use sorter transformation in joins?
Reusable transformation and shortcut differences
What is mapping debugger?