Skip to main content

How can you recognize whether or not the newly added rows in the source are gets insert in the target?



                                                                                                                                                                      
Scenario:
How can you recognize whether or not the newly added rows in the source are gets insert in the target?

Solution:

In the Type2 mapping we have three options to recognize the newly added rows
Version number
Flagvalue
Effective date Range

If it is Type 2 Dimension the above answer is fine but if u want to get the info of all the insert statements and Updates you need to use session log file where you configure it to verbose.

You will get complete set of data which record was inserted and which was not.


Comments

Post a Comment

Popular posts from this blog

SQL Transformation with examples

============================================================================================= SQL Transformation with examples   Use : SQL Transformation is a connected transformation used to process SQL queries in the midstream of a pipeline . We can insert, update, delete and retrieve rows from the database at run time using the SQL transformation. Use SQL transformation in script mode to run DDL (data definition language) statements like creating or dropping the tables. The following SQL statements can be used in the SQL transformation. Data Definition Statements (CREATE, ALTER, DROP, TRUNCATE, RENAME) DATA MANIPULATION statements (INSERT, UPDATE, DELETE, MERGE) DATA Retrieval Statement (SELECT) DATA Control Language Statements (GRANT, REVOKE) Transaction Control Statements (COMMIT, ROLLBACK) Scenario: Let’s say we want to create a temporary table in mapping while workflow is running for some intermediate calculation. We can use SQL transformat...
1 comment
Read more

Informatica Quiz: Set 1

                                                                                                                                                                    ...
2 comments
Read more

Convert Numeric Value to Date Format

                                                                                                                                                                     ...
2 comments
Read more