GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 603 of 644    Print  
Target Details Verification
If the records are transfered from Source to target and if you want to check whether all the records are stored in the target. What are the possible ways to check that.


  
Total Answers and Comments: 3 Last Update: April 08, 2009     Asked by: sarun5 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: atif054
 
Just check the session log for number of rows read and write.

Thanks,
ATIF

Above answer was rated as good by the following members:
DK_Reddy
February 25, 2008 12:20:18   #1  
thaneshkadi Member Since: February 2008   Contribution: 2    

RE: Target Details Verification

hi

i think it is of 2 ways you can find.

1. a) find out how many number of rows are there in the source using basic sql query.
e.g select * from source_table.

b) execute the work flow. in that from ' properties ' we can find how many number of rows are loaded sucessfully.

2. a) repeat 1.(a) step.

b) now find out how many number of rows are there in the target using basic sql query.
e.g select * from target_table.

please correct me if i am wrong


thanesh


 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
October 14, 2008 16:59:21   #2  
atif054 Member Since: October 2008   Contribution: 1    

RE: Target Details Verification
Just check the session log for number of rows read and write.

Thanks
ATIF

 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
April 07, 2009 19:14:08   #3  
DK_Reddy Member Since: April 2009   Contribution: 14    

RE: Target Details Verification
By viewing session.log file-Target load summary
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape