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
why do we go for update strategy tr in SCD rather using the session properties?
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
why union transformation is active transformation?
What is a router transformation?
write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15
without matching columns in two tables. how can you join
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.
What is a command that used to run a batch?
Explain the different kinds of facts.
What is the Hierarchy of DWH?
Is LOAD MANAGER AND LOAD BALANCER same in informatica?
What is the meaning of decode in informatica?