HCL healthcare

 hcl health care f2f second round interview asked more uestions on microservice
1.apim manage all apis in one place
2.sql profiler in one for different database like mongodb and sql

3.how to prevent junior developer from code push
4.remove duplicaet fROm sql table
5.jwt hashing
6.comunit one api end point in another endpoint eg address in inventory method.
7.how you know prod deplyed (kubctl).

code quality

 code metrics in visual studio code
search in google for code quality

Capgemini Interview

 capgemini famous interview question

List<int> A = new List<int>();

A.add(1);

List<int> B=A;

B=new List<int>();

B.Add(2);

A.add(3);

answer?

dropdownsearch for dyanmic fields

   I’ve enabled searchable dropdowns for all dynamic dropdown controls in Assignment Details.

What I changed

• Added a dropdownSearch map in assignment-details.component.ts.
• Added ngx-mat-select-search inside every dynamic dropdown in assignment-details.component.html.
•    <ng-template #dynamicOptions>
•       <mat-option>
•         <ngx-mat-select-search
•           [(ngModel)]="dropdownSearch[field.ControlName]"
•           [ngModelOptions]="{ standalone: true }"
•           [placeholderLabel]="'Search...'"
•           [noEntriesFoundLabel]="'Not found'"
•         ></ngx-mat-select-search>
•       </mat-option>
•       <mat-option
•         *ngFor="
•           let option of field.Options
•             | stringFilterBy: dropdownSearch[field.ControlName]:'Name'
•         "
•         [value]="option.Value"
•       >
•         {{ option.Name }}
•       </mat-option>
•     </ng-template>
• Wired filtering using the existing stringFilterBy pipe on option.Name.
  

private destroy$ = new Subject<void>();

dropdownSearch: Record<string, string> = {};

DB PRod issues

 Production data transer issue i have faced

not using where update command using transaction
>>tansfer larger amount of data from dev emp table to test emp table mistate first load  less dpendent data
>> functions and tables and veiws 
then sps
>>it taking 40 mnts for 50k records.

dotnet 2026

 raodmap

when you order by two columns use this.imp

 

SELECT *

FROM dbo.tbl_WorkFlowMembers w

WHERE w.WorkFlow_ID IN (

    SELECT WorkFlow_ID

    FROM dbo.tbl_WorkFlow

    WHERE country_code = 'BE'

)

ORDER BY 

    w.WorkFlow_ID,

    w.Approver_Sequence DESC;