ETL Testing | Unix Interview Questions & Answers | Linux commands interview questions | Part 1

[@vinayrb8682]

Very much help from these unix command usages Tqs for making video on good content of unix command.

[@manasayejandla6634]

I could have seen this video earlier 😥. Half of these questions I have came across in interview but no idea at that time. Now it's very clear. Thnqq so much sir for this useful info..

[@etlqalabs5048]

Great , keep watching and keep sharing with your friends who may also benefit

[@muralivarmamantena6899]

sir Excellent explannation.clarified

[@harishmahale7180]

Very informative

[@chakrigovindarajulubingi459]

Great

[@pravinm1490]

nice

[@prashantsawale3903]

thank you

[@rajt5218]

Helpful

[@CK-ir2ke]

It's really very helpful content sir. Not only this each and every video series is very crystal clear& important 🙏. Sir can u make one project on Informatica development and testing that project for adding in resume.

[@vishnud6532]

Hi, Please can you explain 11:13 sort -t again, in this video it is not explained

[@etlqalabs5048]

-t is used to tell that what is field separator, in this file we have used comma as separator between fields so we have used comma (","). hope this helps

[@bommareddynarasimhareddy9508]

Can you upload Linux Interview questions and answers Part 2

[@surajpatil3579]

Sir, If possible explain get & put commands also..

[@neharoy6859]

1)how to load multiple files in informatica came in same time using unix?...Can someone pls help me with the answer 2)how to implement etl folder contains many files and in that need to load the oldest file in informatica

[@etlqalabs5048]

In real time , Informatica extract is defined to locate the file to fetch from remote server such as ftp server which the source files are delivered on predetermined time everyday/ weekly as per requirement and when informatica jobs runs as per scheduled time, it picks up that file and process. Informatica job can have multiple files picked up from same Linux directory if there are multiple sources defined in informatica transformation. Hope this clarifies your question. Can just watch some of my video that covering extraction from file based source to get and idea how do we define the source qualifier to pick the file from source location

[@vinaychourasiya8366]

didn't get this part- sort -t "," -nrk 4 -- in this you have used k as field and in this cut -d "," -f4 - f as a field--- can you explain this lit bit more. I am not a Unix person so this might be the reason I didn't get that.

[@neharoy6859]

how to see log files for specific date of 25th only but you are not getting the timestamp? Can someone pls help me with the answer

[@etlqalabs5048]

Ideally the logs should be given with timestamp if it's writing in the same log file . In real world scenario, log files name itself are created with date and time stamp so that we can check the transaction of the past. Probably you can clarify what's the purpose of log file if this can serve the purpose of basic requirement. Anyways you can always check the latest 10 lines from log using $ tail - 10 filename

[@hassanalisoofi2536]

my unix cant find file but exist can you help me

[@shivargvfilm1989]

can you tell me how to practice these linux commands .. i am using windows... is there any platform where we can practice linux for free...

[@etlqalabs5048]

Yes - you can download ubuntu with oracle vm virtual box . that's free . even there are some online editor you can use but they are limited with some commands only

[@shivargvfilm1989]

@@etlqalabs5048 Thank you

[@mdr8244]

Why etl tester needs to learn unix?

[@etlqalabs5048]

I have explained the reason in the initial of this video- since ETL essentially designed to extract the data from multiple types sources like databases, files based systems etc...so while you verify the source /target when file is used , you would need some scripting language to figure out row count, duplicates etc..hence either you use Linux or python pandas etc.. however most of the developers use Linux as scripting and also as a server hence its must have skill if you really want to be best at your job. Hope this clarifies your question

[@Shubhshinde94]

Thank you sir this is helpful 👏

[@Shubhshinde94]

Sir could you please help me with my career I messed up with so many things..

[@etlqalabs5048]

@@Shubhshinde94 Pls drop me an email with a bit of your introduction, background . I will try to guide you. Email me to “[e-mail]”

[@Shubhshinde94]

@@etlqalabs5048 ok sir thank you .😊

[@viveksrinivas548]

Thank you

[@sivarachagunta]

Thanks