1-844-696-6465 (US)        +91 77600 44484        help@dezyre.com

If we want to compare records from a source system to data that is just added to SFDC how do we do that?



0
Say I have 40k records in S System A and then 5 k in Source system B. I add the records to SFDC using data loader. How can i test to see that all the 45 k records. Do I need to write SQL to test SFDC data?

2 Answer(s)


0

@Parshant :- If I got ur question correctly, you want to check data for all records in SFDC. This can achieved as u said by firing a SOQL in SFDC or extract data using dataloader in a csv and then compare with source system.

0

Yes Prashant to count number of records you have to fire SOQL not SQL and query will be executed in developer console, query will be something like this Integer count = [select count() from object_name];

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password