On lookup on any table we can get only a)any value or b)last
value but if i need both duplicate values How can i achieve?
- 3 Answers
- 6217 Views
- I also Faced
- E-Mail Answers
Answer Posted / suresh
actually on lookup two ways we can put the values normally
we put a anyvalue(if you want to both duplicate values).
when we use SCD type 2 its must and should put on last value
into the look up Bcoz it should store the history.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is powercenter on grid?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is the commit type if you have a transaction control transformation in the mapping?
What are the measure objects?
What is repository manager?
What is InformaticaPowerCenter?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
have u done any performance tuning? how u ll do?
complex mapping ur project u r invlve can u explain and give real time example give me ?
How can you increase the performance in joiner transformation?
What is complex mapping?
Implementation methodology
How can we create index after completion of load process?
Explain about Informatica server process that how it works relates to mapping variables?
How can you validate all mappings in the repository simultaneously?
