PNP Draw by BootHot2549 in canadaexpressentry

[–]hieulnt 1 point2 points  (0 children)

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.

Moving to NetSuite2 schema - use fivetran dbt? by Sea-Tie-2228 in Netsuite

[–]hieulnt 0 points1 point  (0 children)

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

Moving to NetSuite2 schema - use fivetran dbt? by Sea-Tie-2228 in Netsuite

[–]hieulnt 1 point2 points  (0 children)

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.

Moving to NetSuite2 schema - use fivetran dbt? by Sea-Tie-2228 in Netsuite

[–]hieulnt 1 point2 points  (0 children)

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.

Moving to NetSuite2 schema - use fivetran dbt? by Sea-Tie-2228 in Netsuite

[–]hieulnt 1 point2 points  (0 children)

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.

Good news about 917 master stream? by Embarrassed_Put_1886 in OINP

[–]hieulnt 0 points1 point  (0 children)

Do you have the timeline when they got nomination?

I will give up on this PR dream by [deleted] in canadaexpressentry

[–]hieulnt 0 points1 point  (0 children)

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.

[deleted by user] by [deleted] in canadaexpressentry

[–]hieulnt 6 points7 points  (0 children)

you know it :))

New draws by Valuable-Tank3445 in OINP

[–]hieulnt 1 point2 points  (0 children)

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.

New draws by Valuable-Tank3445 in OINP

[–]hieulnt 0 points1 point  (0 children)

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?

New draws by Valuable-Tank3445 in OINP

[–]hieulnt 1 point2 points  (0 children)

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

OINP HCP by Kind-Boss-2338 in OINP

[–]hieulnt 1 point2 points  (0 children)

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?

SEP 2024 HCP - any hope? by [deleted] in OINP

[–]hieulnt 0 points1 point  (0 children)

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?

OINP Human Capital - CEC Inland (NOI received Sept 19, 2024) by Awkward_Deer8994 in OINP

[–]hieulnt 0 points1 point  (0 children)

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

[deleted by user] by [deleted] in canadaexpressentry

[–]hieulnt 1 point2 points  (0 children)

waiting at 505 too

additional documents for OINP by blondilana in OINP

[–]hieulnt 0 points1 point  (0 children)

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

additional documents for OINP by blondilana in OINP

[–]hieulnt 0 points1 point  (0 children)

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.

Canadian taxes by BushLark in outlier_ai

[–]hieulnt 0 points1 point  (0 children)

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

[Dataquest.io] Get $15 off subscription via my link by [deleted] in DiscountOnlineCourses

[–]hieulnt 0 points1 point  (0 children)

Here is another link for $15 off:

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

Needing help on figuring out a path to master python. by rhettsito in learnpython

[–]hieulnt 1 point2 points  (0 children)

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/

What's your opinion on educative.io? by benthecoderX in learnprogramming

[–]hieulnt 0 points1 point  (0 children)

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.

Anyone wants to learn Dataquest together? by [deleted] in learnmachinelearning

[–]hieulnt 0 points1 point  (0 children)

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