Target increases every day even though no new record was inserted



Target increases every day even though no new record was inserted..

Answer / Lavi Sahu

The target increasing every day without any new records being inserted might indicate a programming issue or a data entry error. It is recommended to review the code for the system that generates the targets, examine the database table structure and data integrity, and check if there are any scheduled updates or batch processes that could be causing this issue.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,


what is difference between mapping and mapplet ?

2 Answers   TCS,


In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,


checkout and checkin in informatica 8.6

3 Answers   TCS,


how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,


what type of transformation is not supported by mapplets?

4 Answers   CTS,


Under what conditions selecting sorted input in aggregator will still not boost session performance?

1 Answers  


If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,


How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers  


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  


How can you validate all mappings in the repository simultaneously?

1 Answers  


What is the Difference between DSS & OLTP?

5 Answers  


Categories