performance wise which one is better in joiner and lookup
transformation
Answers were Sorted based on User's Feedback
How can yoU improve session performance in aggregator transformation?
how to through logic of informatica using the push down optimization into oracle.
What are the joiner caches?
What you know about transaction control transformation?
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is the use of source qualifier?
How can we delete duplicate rows from flat files?
There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
From where we can start or use pmcmd?
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.?