VjayishgData DefinitionsData curation is the organization and integration of data collected from various sources. It involves annotation, publication and…Apr 2, 2023Apr 2, 2023
VjayishgRemoving file based on last modified time (Minutes):Get-ChildItem -path \\ServerName\Drive$\TestDeleteFile\ | where {$_.Lastwritetime -lt (date).addminutes(-1)} | remove-item.Apr 2, 2023Apr 2, 2023
VjayishgExcel to SQLServer DB table Data importParam( [Parameter(Position=0, Mandatory=$true)] [string]$tblname, [Parameter(Position=1, Mandatory=$true)] [string]$filepath )Apr 2, 2023Apr 2, 2023
VjayishgOracle health checkup:ps -ef | grep “ora_” | grep -v grep ps -ef | grep “lsnr” | grep -v grep archive log list; ** make sure Automatic archival is “Enabled”Apr 2, 2023Apr 2, 2023
VjayishgON-PREMISES SOURCE DATA FILE DATASET REFRESH USING POWERBI GATEWAY READING CSV FILE USING…Objective: On-Premises Source Data File Dataset Refresh Using Powerbi Gateway Reading Csv File Using PowerShell Script.Aug 4, 2022Aug 4, 2022
VjayishgPOWERBI REPORT REFRESH WITH REPLACE &SCHEDULING POWERBI — DATASET REFRESHAug 4, 2022Aug 4, 2022