IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
No Answer is Posted For this Question
Be the First to Post Answer
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.?
Normalizer transformation is not involved in Mapplet.. why???
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
how did u understand business requirement?
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com
What is data transformation manager process?
Types of error logs in Informatica?
What are active transformations.
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?
Can we get 1st record through Informatica(without sequence number).
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
Enlist few areas or real-time situations where informatica is required.