Informatica - How can u recognise whether or not the newly added rows in the source r gets insert in the target ?

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 71 of 644

How can u recognise whether or not the newly added rows in the source r gets insert in the target ?

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

Total Answers and Comments: 3

Last Update: April 21, 2009

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

December 14, 2005 10:43:31

rishi

RE: How can u recognise whether or not the newly added...

If it is Type 2 Dimension the abouve 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.

Is this answer useful? Yes | No

October 04, 2007 01:13:52

Prasath

RE: How can u recognise whether or not the newly added...

Just use debugger to know how the data from source moves to target it will show how many new rows get inserted else updated.

Is this answer useful? Yes | No

April 21, 2009 15:12:07

ASHOK1324

Member Since: April 2009 Contribution: 36

RE: How can u recognise whether or not the newly added rows in the source r gets insert in the target ?

In the SCD Type2 we have three options to recognise the newly added rows: 1. Version number 2. Flag value 3. Effective Date Range

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank