Sir, your video was not playing. Its showing only the page whre your mentioned source and target table data.
@srtechnologiesravindraredd5303
9 ай бұрын
Oh okay 👍
@gayathrivg834
9 ай бұрын
Select Distinct Name, to_number(cust_id),to_number(order_id),to_number(sales),to_number(nvl(status,0)) from source Minus Select * from Target
@ramayyavu3459
4 ай бұрын
Thank you for taking effort to spread your knowledge . User is looking at the static page of order table only. But your explanation screen doses not appear to visibility . Can you able to fix it . Thank you once again .
@SANJAYYADAV-hm2bs
9 ай бұрын
Select distinct Name, Cust_Id, Order_Id, Sales, case when status is null then 0 else status end as Status from Source minus Select * from Target;
@maheshreddy887
9 ай бұрын
SELECT DISTINCT Name, TO_NUMBER(Cust_Id) AS Cust_Id, TO_NUMBER(Order_ID) AS Order_ID, CASE WHEN Sales = 'Null' THEN 0 ELSE TO_NUMBER(Sales) END AS Sales, Status FROM source_data; minus select * from SELECT * FROM target_data;
@SANJAYYADAV-hm2bs
9 ай бұрын
@maheshreddy887 we can't equate null value. Sales = 'Null' is wrong.
@vikindahe1642
7 ай бұрын
this is very important video to clear basics, can we see that test case and script screen please
@dreamhousepune2051
7 ай бұрын
Thank you so much Sir, I got job.
@merlinelizabethmathew982
8 ай бұрын
Sir, Only the scenario page is visible, other than that whatever you are doing is not visible in this video :(
@srtechnologiesravindraredd5303
8 ай бұрын
Yes I knew that...it was by mistake
@venkateshpappu-h2w
9 ай бұрын
Hi Sir, Thanks for the valuable content. i have one query can you provide me with the answer i have a registration table like below Table Name: Registrations Client_ID Client_Name Year - Ex 2023,2022, 2021 etc Month - Ex January, Feburary etc Month_Num - Ex 1,2 etc now i need records between 2022 nov - 2023 dec. could you please help me with the query
@srtechnologiesravindraredd5303
9 ай бұрын
I have answered the question in the video
@venkateshpappu-h2w
9 ай бұрын
@@srtechnologiesravindraredd5303 Thank you Sir ..
@ashwiniraikar2507
6 ай бұрын
No video only audio
@swapnalimisal3736
6 ай бұрын
Sir please provide the videos with queries on etl tool
@srtechnologiesravindraredd5303
6 ай бұрын
Here is the same thing I have provided..generally developers they does development on ETL tools, your going to get the mapping document like above in the video..you have to write the queries for the same...what is the confusion?
@swapnalimisal3736
6 ай бұрын
Yes...could you pls provide the queries ..it will be helpful
@srtechnologiesravindraredd5303
6 ай бұрын
@@swapnalimisal3736 I am explaining the same in the video right..can you please be specific..
Пікірлер: 19