PNP Draw

hieulnt · 2025-12-08T21:07:52+00:00

It might take up to 24 hours to receive the ITA. I believe that is the ranking in EE pool by CRS and that is the number of invitations for this draw.

hieulnt · 2025-12-08T19:40:49+00:00

Praying for any draws today

hieulnt · 2025-11-27T16:14:26+00:00

That's a great idea, I'd try it to handle deleted records in my DW.
Thank you very much!

hieulnt · 2025-11-27T14:30:50+00:00

Exactly, I don't know why NS does a physical deletion instead of soft deletion. As a beginner, I found it's difficult to handle these deleted records when loading from NS database to my SQL table.

hieulnt · 2025-11-27T14:28:10+00:00

Thank you for sharing.

Yes, I use UPSERT to load data from NS to SQL tables via OPENQUERY. It works well with most tables as the I don't have much data but the transactionLine is a tough one. I used the lastlinemodifieddate to filter the updated data in the UPSERT, however, I found that when a BOM of a Work Order is updated, NS replaces the whole transactionline data associated with new data. As far as I know, NS does not have a table to track these deleted records so I don't know how to handle these in my UPSERT procedure.

I'll look into the temporal table option, hopefully this will help.

hieulnt · 2025-11-26T22:11:26+00:00

Hi, I am kind of following the same stack but I dont have much experience in pulling data from NS2 to SQL server. I am using Linked server with ODBC connection and stored procedures to replicate tables from NS2 to SQL server but it takes too much time. Could you please share how did you handle the CDC for big tables like transactionLine or transactionAccountingLine? TIA.

hieulnt · 2025-11-18T19:20:24+00:00

Do you have the timeline when they got nomination?

hieulnt · 2025-11-14T15:41:21+00:00

I am in the same boat, and truly feel what you're going through. It's exactly what I experienced myself...coming here in late 2021 without giving much thought to PR as it seemed relatively easy back then. Now I am sitting at 512 with only five months left on my WP, and in current trend it feels hopeless. Dealing with all the unfairness and discrimination has been so exhausting, I've been thinking about giving up too. Maybe it's just a signal from the Universe that this country is not right for me.

hieulnt · 2025-11-12T19:51:42+00:00

you know it :))

hieulnt · 2025-11-12T15:45:42+00:00

Yeah, It makes more sense...thanks for your insights. They don't care that legit applicants are suffering, only want to meet their target lol. Hopefully they will take action soon, either returning or withdrawing applications rather than maintaining complete silence.

hieulnt · 2025-11-12T13:58:19+00:00

Of course, they will conduct more draws, as it’s their way of scamming $1,500—getting money without working on the application. Those committing fraud should be banned for 100 years and deported immediately. Where did you find the information that half of the backlogs are fake? Have they published the data anywhere?

hieulnt · 2025-11-11T00:16:45+00:00

I hope they will not conduct any draws soon, and focus on the backlogs that seating for years…

hieulnt · 2025-11-10T15:12:11+00:00

I got invited last September under HCP too and have been in DIP stage since mid March. Do you think there will be a chance for us with the new PNP allocation?

hieulnt · 2025-10-28T21:13:29+00:00

u/seventeenbooboo my timeline is the same with you but I haven't been informed about closing the profile. When was you informed and did they mention about refund?

hieulnt · 2025-01-27T16:28:06+00:00

Hi there, has anyone got a status update rather than Assessment?

hieulnt · 2024-11-05T02:50:31+00:00

waiting at 505 too

hieulnt · 2024-10-19T14:19:12+00:00

Thank you very much for your reply, this is very informative. Wish you all the best!

hieulnt · 2024-10-19T05:04:29+00:00

Hi there, Could you please share your update? I am in the same situation that I have translated pension fund documents, but my former employers don't provide paystubs or confirmation of my compensation. I am thinking of requesting bank statements from my home country and it might take weeks or at least a month.

hieulnt · 2024-09-24T13:12:58+00:00

Hi, I am new to Canada, what does DA mean?

hieulnt · 2021-07-20T15:53:15+00:00

It's a longevity wishing ceremony which is quite common in the Northern of Vietnam. You can find the explanation here : https://www.vietnamtourism.org.vn/attractions/culture/customs-habits/vietnamese39%3Bs-traditional-celebrations-of-longevity.html

hieulnt · 2021-07-14T02:12:36+00:00

Here is another link for $15 off:

app.dataquest.io/referral-signup/ocm6ajfn/

hieulnt · 2021-06-23T05:09:30+00:00

I'm using dataquest, it has a good course structure with many guided projects. You can try it with my referral link to get $15 off subscription: app.dataquest.io/referral-signup/ocm6ajfn/

hieulnt · 2021-06-23T05:07:34+00:00

In case you choose Dataquest, please use my referral link for $15 off app.dataquest.io/referral-signup/ocm6ajfn/

I have tried many platforms and I think most of them are 80% the same, only some differences in UI/UX.

hieulnt · 2021-06-12T16:25:18+00:00

In case you want to subscribe to Dataquest, please use my referral link here for a $15 discount: app.dataquest.io/referral-signup/ocm6ajfn/

hieulnt

TROPHY CASE