thaneshkadi

 Profile Answers by thaneshkadi 

• Feb 25th, 2008

 

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

atif054

 Profile Answers by atif054 

• Oct 14th, 2008

 

Just check the session log for number of rows read and write.

Thanks,
ATIF

DK_Reddy

 Profile Answers by DK_Reddy Questions by DK_Reddy

• Apr 7th, 2009

 

By viewing session.log file-Target load summary

rajesh_kare

 Profile Answers by rajesh_kare 

• Oct 21st, 2010

 

 You probably need to check the session log or task details

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 16th, 2011

 

I guess in the workflow monitor, just right click on the session and select get run properties, this option shows total source rows, no of rejected rows an total rows moved to target.

skaur29

 Profile Answers by skaur29 

• Nov 17th, 2011

 

1) Check Session Logs
2) Use Preview Data option for Target in PowerCenter once session is completed
3) Sql queries if it is a Relational database

Rishak

 Profile Answers by Rishak 

• May 21st, 2012

 

If you want to check the records,you can directly use MINUS query for eg

Code
 

Hope this will help

Thanks
Risha