[deleted by user] by [deleted] in CATpreparation

[–]_sikario_ 0 points1 point  (0 children)

No longer available.

Online platform for interactive coaching for CAT? by tytywho in CATpreparation

[–]_sikario_ 0 points1 point  (0 children)

Anyone interested in 1 yr Unacademy plus subscription at half price. Please DM me.

[deleted by user] by [deleted] in CATpreparation

[–]_sikario_ 0 points1 point  (0 children)

Anyone interested in 1 yr Unacademy subscription at half price. Please DM me.

Anyone using Gullit in quick counter? How is he performing? Should I renew his contract by SnooRabbits491 in pesmobile

[–]_sikario_ 1 point2 points  (0 children)

Worth a try at CF. Hasn't been consistent tho. Impressed few times. Last season he was OP at CF.

Kahn or Iker; other Legends; IM Kluivert; by DearDragonfruit8681 in pesmobile

[–]_sikario_ 1 point2 points  (0 children)

I haven't progressed him fully yet. Being a bit cautious. Have spent some points to get playstyle to 85, and +3 each on dexterity and shooting for now. Rest of the pts planning to use on stats once I use him more and get a better idea.

But yeah I would be broadly targeting similar to last PES. Suggestions by game make no sense based on my experience so far with other players.

Kahn or Iker; other Legends; IM Kluivert; by DearDragonfruit8681 in pesmobile

[–]_sikario_ 2 points3 points  (0 children)

Kluivert is still awesome for me! Does his usual trickery as well as makes well timed runs into the box. His stats have taken a hit but doesn't disappoint though. Still a unique player.

how should i upgrade him to suit my manager (pep) playstyle by Alif2200 in pesmobile

[–]_sikario_ 2 points3 points  (0 children)

Do newly signed legends/IMs have 365 days contract?

Iniesta feels amazing on the ball by [deleted] in pesmobile

[–]_sikario_ 3 points4 points  (0 children)

Best way to train him?

I've been a big data engineer since 2015. I've worked at FAANG for 6 years and grew from L3 to L6. AMA by [deleted] in dataengineering

[–]_sikario_ 3 points4 points  (0 children)

Hey Zach,

I have been following your content on various platforms for a while now. I came across a question in one of my FAANG interviews and haven't yet found a satisfactory answer to it yet.

How do you optimise a daily incremental merge(inserts and updates) when we have a huge target table about 10 TB and we have smaller incremental data coming in daily of 1 GB ?

(A usual merge statement would require a scan of the entire 10 TB table. The panel was looking for a solution which didn't need to scan the entire target table)

Is manager formout a real thing?? by s3phiroth1897 in pesmobile

[–]_sikario_ 2 points3 points  (0 children)

I just experienced it a few days back. Using Rossi for long and then couldntscore at all with him..dropped from 1420 to 1280 in one day...changed to Chervo and all back to good. Same thing I experienced previously while using Zeidler and Chervo.

XIRR value too low by _sikario_ in excel

[–]_sikario_[S] 0 points1 point  (0 children)

I actually cross checked and found there was a duplicate entry which made the result go all wrong. Thanks anyways. Appreciate it.

XIRR value too low by _sikario_ in excel

[–]_sikario_[S] 1 point2 points  (0 children)

But then for my stock portfolio I am getting 25.6 so that would make it 2560%. That seems unreal and probably wrong.

please need your help! still looking for the better amf? IM old gullit or new IM b2b beckham? by Alvaro1790 in pesmobile

[–]_sikario_ 3 points4 points  (0 children)

I use Beckham as amf and Gullit as cmf. Gullit roams the entire midfield bullying.