VjayishgData DefinitionsData curation is the organization and integration of data collected from various sources. It involves annotation, publication and…3 min read·Apr 2, 2023----
VjayishgRemoving file based on last modified time (Minutes):Get-ChildItem -path \\ServerName\Drive$\TestDeleteFile\ | where {$_.Lastwritetime -lt (date).addminutes(-1)} | remove-item.1 min read·Apr 2, 2023----
VjayishgExcel to SQLServer DB table Data importParam( [Parameter(Position=0, Mandatory=$true)] [string]$tblname, [Parameter(Position=1, Mandatory=$true)] [string]$filepath )2 min read·Apr 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”1 min read·Apr 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.3 min read·Aug 4, 2022----
VjayishgPOWERBI REPORT REFRESH WITH REPLACE &SCHEDULING POWERBI — DATASET REFRESH4 min read·Aug 4, 2022----
