Explain the types of lookup transformation?
No Answer is Posted For this Question
Be the First to Post Answer
I have 1200 records how can u send it in aggregator with good performance issues?
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
what is materialized view?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
where to store informatica rejected data?
I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
Explain dynamic target flat file name generation in informatica
can we override a native sql query within informatica? How do we do it?
whether Sequence generater T/r uses Caches? then what type of Cache it is