How can a Lookup with Dynamic Cache be replaced in a
mapping? Explain.
- 2 Answers
- 7118 Views
- TCS, I also Faced
- E-Mail Answers
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 are the components of workflow manager?
What are the active and passive transforamtions?
Tell me one complex query in oracle ?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
what is the drillup & drill down?and use of the drill up and drill down?
How to display First letter of Names in Caps?
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
How to delete the data in the target table after loaded.
Which gives the more performance when compare to fixed width and delimited file ? and why?
what is the flat file partition and where have to specify it
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
Teradata 
