when i run this this configuration iam getting two mof files with "DSC-Client.mof" and "DSC-SQL2014.mof".
Now i have to run LCM for that can i generate guid and checksum for each mof file and placed in the path "C:\Program Files\WindowsPowerShell\DscService\Configuration" and update my LCM with latest GUIDS for 2 mof files is necessary.
How my LCM to be drafed for multiple nodes
You can author configurations like this where one script generates multiple configurations but there isn't much benefit for the complexity it adds. One script per configuration makes for a nice clean CI test environment.