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.

Questions by sarun5   answers by sarun5

Showing Answers 1 - 7 of 7 Answers

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

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

Rishak

  • May 21st, 2012
 

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

Code
  1.  SELECT  count(*) FROM source

  2. minus

  3. SELECT count(*) FROM target

  4.  

  5.  


Hope this will help

Thanks
Risha

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions