- Видео 252
- Просмотров 346 036
DataPundit
Индия
Добавлен 19 июл 2020
This Channel is to educate / train / coach aspirants in technical fields , very among in those are Abinitio , Python, SQL , AWS , Azure, GCP , Machine Learning , Deep Learning. Apart from technical tools and technologies this also has fundamental concepts regarding the data warehousing.
This Channel also has some random videos for ecology and fun, just to be near with nature and real life beside the technical world.
This Channel also has some random videos for ecology and fun, just to be near with nature and real life beside the technical world.
Banking Application Account Processing in Continuous Flow Graph in Abinitio
Banking Application Account Processing in Continuous Flow Graph in Abinitio
(a) Basic Account Processing
Subscribe
Continuous JOIN with DB
Continuous Update Table
Multi publish
(a) Basic Account Processing
Subscribe
Continuous JOIN with DB
Continuous Update Table
Multi publish
Просмотров: 46
Видео
MAX CORE in JOIN in Abinitio
Просмотров 95Месяц назад
MAX CORE in JOIN in Abinitio Please visit my blog for more details: datapundittechblog.blogspot.com/2024/05/max-core-in-join-in-abinitio-in-memory.html
Batch vs Continuous Graphs in Abinitio - A Revision
Просмотров 109Месяц назад
Batch vs Continuous Graphs in Abinitio - A Revision We will talk about below- a. Batch versus Continuous b. Type Of Continuous Graphs c. Continuous Graph is used when? Please check my blog for more details for class notes: datapundittechblog.blogspot.com/2024/05/batch-vs-continuous-graphs-in-abinitio.html
MAX CORE in Rollup in Abinitio
Просмотров 76Месяц назад
MAX CORE in Rollup in Abinitio Please visit my blog on algorithm datapundittechblog.blogspot.com/2024/05/max-core-in-rollup-in-abinitio-rollup.html
MAX CORE in SORT in Abinitio | SORT algorithm in Abinitio
Просмотров 992 месяца назад
MAX CORE in SORT in Abinitio Please visit my blog here datapundittechblog.blogspot.com/2024/05/maxcore-for-abinitio-sort-algorithm-for.html
Dynamic Subgraph in Abinitio
Просмотров 1502 месяца назад
Dynamic Subgraph 1. subgraph that can be updated independently of the parent graph or the graph which uses it 2. parent graph maintains a pointer to the dynamic sub graph but the contents of the dynamic sub graph not loaded until parent graph runs visit blog for more details: datapundittechblog.blogspot.com/2024/05/dynamic-subgraph-in-abinitio.html
Linked Subgraphs in Abinitio
Просмотров 1333 месяца назад
What are Embedded Subgraphs? What are Linked Subgraph? What are Dynamic Subgraph? Please check the blog as below: datapundittechblog.blogspot.com/2024/05/linked-subgraphs-in-abinitio.html
Abinitio Interview Question 46
Просмотров 2873 месяца назад
Abinitio Interview Question 46 56.1 Calcucate the difference of date in days 56.2 Calculate the Month Start Date and Month End date for the given date 56.3 Calculate the Quarter start date and Quarter End Date for the given date 56.4 How to get the difference between 2 times in minutes 56.5 How to convert a string like "2/22/2015 9:54:02 AM" having AM/PM to DateTime datatype? visit my blog for ...
Abinitio Interview Question 45
Просмотров 2443 месяца назад
Abinitio Interview Question 45 Get the unique values from the input data Input code, country 1, India 2, Mumbai 1, USA 2, Newyork 1, UK 2, Edinburgh 2, London output code, countries 2, India,Mumbai 2, USA,Newyork 2, UK,Edinburgh,London For course content visit my blog: datapundittechblog.blogspot.com/2024/05/abinitio-interview-question-45.html
Abinitio Interview Question 44
Просмотров 2853 месяца назад
Abinitio Interview Question 44 Take the 2 dates and create end date for first and last quarter. (First date of the quarter , Last Date of the quarter) There will be 2 output fields in the output file. DATE1 = 25102022 DATE2 = 24082023 first_quaryer_start_dt=25102022 01102022 last_quarter_end_d t=24082023 30092023 Please visit my blog for content of class video: datapundittechblog.blogspot.com/2...
Abinitio Interview Question 37
Просмотров 3164 месяца назад
Abinitio Interview Question 37 RollNo,Student_Name, Semister, Sub1_mark 1234, X, I, 50, 1234, X, II, 45, 1234, X, III, 55, 1234, X, IV, 24,
Abinitio Interview Question 36
Просмотров 3354 месяца назад
Abinitio Interview Question 36 EmployeeNo, Prodcut E01, Car E01, Laptop E02, Car Result EmployeeNo | Car_Ind | Laptop_Ind E01 | 1 | 1 E02 | 1 | 0 Visit my blog for notes : datapundittechblog.blogspot.com/2024/05/abinitio-interview-question-36.html
Abinitio Interview Question 35
Просмотров 2644 месяца назад
Abinitio Interview Question 35 Input: Col1|Col2 A | A A | B B | C B | D B | E Output: Col1,Col2, Seq1,Seq2 A, A, 1, 1.1 A, B, 1, 1.2 B, C, 2, 2.1 B, D, 2, 2.2 B, E, 2, 2.3 Visit my blog for notes : datapundittechblog.blogspot.com/2024/05/abinitio-interview-question-35.html
Abinitio Interview Question 40
Просмотров 2834 месяца назад
Abinitio Interview Question 40 seqNo, deptName,citi1, citi2 1, XYZ, Pune, Guwahati 2, ABC, Mumbai, Chennai Output: seqNo, deptName,city 1, XYZ, Pune 1, XYZ, Guwahati 2, ABC, Mumbai 2, ABC, Chennai visit my blog for more detail datapundittechblog.blogspot.com/2024/05/abinitio-interview-question-40.html
Dynamic Generation Of Keys in Abinitio
Просмотров 1855 месяцев назад
Dynamic Generation Of Keys in Abinitio
Meta Pivot In Abinitio Interview Question 46
Просмотров 2435 месяцев назад
Meta Pivot In Abinitio Interview Question 46
Normalizing Nested Vectors in Abinitio
Просмотров 1585 месяцев назад
Normalizing Nested Vectors in Abinitio
Nested Vector Normalization In Abinitio PART 1
Просмотров 2335 месяцев назад
Nested Vector Normalization In Abinitio PART 1
Complex Abinitio Use Case Transform Based Solution
Просмотров 2576 месяцев назад
Complex Abinitio Use Case Transform Based Solution
Vowel Counting Abinitio MAP and Vectors
Просмотров 3026 месяцев назад
Vowel Counting Abinitio MAP and Vectors
Complex Abinitio Use Case Component Based Solution
Просмотров 3567 месяцев назад
Complex Abinitio Use Case Component Based Solution
Nhi samja 😢
no problem, take a break , view other abinitio videos and come back to view it again, i think you are not able to understand regarding map, so view this first ruclips.net/video/AWI_TdIOs0w/видео.html
If both are defined than output -indexes get priority why? Iq question
this is how its defined so one way or other it has to behave in non confused manner is not it?
@ actually in interview i was asked if we define both outputindex and outputindexes then what happens? So i said output indexes gets priority. So he asked why output indexes gets priority?
There has to be some reason na and it’s not even specified in helpfile that why output indexes gets priority
For how many years experience this type of questions are asked?
it depends on interviewer , but what is harm in preparing best for the day
@ yes its good to stay prepared but am finding it tough total experience 3-4 years😅
I hav 1 question, how can we stop the graph in the middle of the execution without using stop button?
use force error in any transform if you want conditional stop or if you want guaranteed stop then use force abort
@ thank you so much sir for replying, can you please clarify how can we force error in transform?
@@Angelica.786 if(in.x=='STOP') force_error("Stop encountered in incoming data for field x"); this is sample , you could have any custom condition as well
Not clear. Pls provide proper code
hello sir , please upload web service call video
good evening sir,
can you please make a video on abinitio with hdfs hive components which are now there on abinitio gde versions 4 and above.
Noted
Hi datapundit you have any idea how to convert ab initio mp file into excel file or stcuture format?
Did not really understand your query.
Could you please explain more on xml files in ab initio examples
As you have shown relationship between interface and DSG, can you explain more on how multiple interfaces in one parent graph can point to the same DSG as show in Parent Graph 3?
Do we provide implementation value to graph interface after inserting in the main graph ?
If i create another Dsg say testDynamic1_DSg which implements the same mgi file. How can i call both the dynamic subgraps - testdynamic and testdynamic1 in the same parent graph ?
Thank u
Please share your contact details
Hi Sir, can we generate a sequence by group ? for example idA 1 idA 2 idA 3 idA 4 and sequence star again to another group idB 1 idB 2 idB 3 idB 4
proper explanation for max core in rollup , first time ever i think i get it
I was following you for past 2 years sir, nice explanation..and also scenarios explanation was too good..thank you sir
Hi Sir..Do you have videos on Ab Initio admin as well ? Like configuration detaols for coop , rpeorter and bridge set up and start ups etc ?
not yet as such , what exactly are you looking for in case?
In this scenario, can we pirnt empid as well ? alongwith min max sal and deptid ?
yes can be done
Could you please let us know, why you have used string_split two times in l_rec_vec definition ?
seems typo, only one is needed
When I'm trying to ssh, I'm getting a prompt to enter password instead of directly loggin in. Any specific reason of this, what needs to be done to be able to ssh?
Follow the steps as it is , if you do then it should through
How should we create 2 way or 4 way mfs system?
2way -> Partition Component-> (use all-to-all flow)->departition(gather running at 4 way)-> o/p I have earlier videos in my playlist
In 5th solution as are need to use sort and rollup on very high data volumne .. is it better solution than 3rd or 4th ?
hi , may be but not always , there is always a context , so here are few alternatives , but the final solution will depend on the try and test strategy with production like data
Your explanation is not clear
Just a suggestion Better to explain with some notes or diagram... BTW your videos are very helpful
yes, this is one of my initial video , these days are all with example, thanks for visiting!!! cheers
Please make video on reading multiple dml files in abinitio
yes ok
Do you offer abinitio coaching??
can you tell me which is the latest version of ab initio used these days?
Best in the business
In the end you said , there will be next session on icff config. However i did not find the same in playlist. Could you please share the link?
yes , I will be covering these concepts with right examples in few days in fact!
InvalidParameterCombination When a ModifyCluster PubliclyAccessible operation is requested, no other modifications are allowed in the same request. Hi I got this above error when I tried to allocate the EIP for redshift,can you please help me in this case?
Use cases for conduct>it are pending I think
Yes I will try soon for that
Input 1 2 3-7 Output 1 2 3 4 5 6 7 Please provide the solution for the above
Would you please create video on call web service get and put
yes i wll do
Hi, Why are we using a rollup here Cant we just use refornat and give ternary condition for car_ind and laptop_ind and assign if product is having car assigned for that emloyee from input Can this indicator value have anything else than 0 and 1? Please clarify Thanks in advance
Yes , go ahead , can have multiple ways to solve any problem
Thanks for sharing
My pleasure,btw thans for visiting,please share and subscribe if not done ✅
Can you share some interview questions on metaprogramming?
Ok I will do post
@@datapundit Thanks
Hi sir, your voice is getting low. Explanation is quite good 😊, thank you
Noted
Hi ! how to become a member and access the videos? Please help
Hello Sir ! How to become a member ? I am not able to find that option here . Please help , I wanted to access all the lecture videos .
How can we resolve field level analysis for meta pivot component using doc transform??
So if the file size is above 2GB , then we should go for Rollup / Scan. Is it correct..
yes , btw it depends on circumstances
Hi Sir, I really appreciate the efforts that you are putting in to share your valuable knowledge. I do have one question on schema change or schema drift happening from the source s3 side. How to update the redshift table with latest schema here. Will it automatically get updated or do we need to handle this some how? If we need to handle this, where we can add this and what are the options available?
Hi Sir, can you please provide this notepad with all the questions and answers from all your videos..
Check here datapundittechblog.blogspot.com/2024/05/abinitio-interview-question-43.html Mostly All video will have link in here
Why use 2nd Lambda function? Event bridge can directly trigger Glue Jobs right?
Hi Sir, Is there a way to execute queries with functions in the graph? I have tried to execute an input table with querie that requires functions and it gives me an error
Develop stored procedure and call it,
@@datapundit thanks !
Tell what is the dml in reformat and normalize. That would be more helpful to learners like me
something which is described as input port and outport is respective dmls, let me know for any specific thing. between record and end is the dml only
@@datapundit input dml and roll up in dml Nad out dml. If it is possible can you pls do another vedios as part-2. Thank you so much
@@maheswarareddytelugu Ok , but I am not done any Rollup here , do you want to me create vector from scaler type?
@@datapundit yes please
@@datapundit even if you give us reformat and normalize in and out dml that would be great help us
I have a question but not related to Micrograph. Say we get 100 files from a source system and I do not want to process all files at once as it would hinder the CPU. So I need the process only 5 files at a time and when 1 of them complete it should pick the next. So basically I need to run only 5process in parallel at a time. How to achieve this
I have a video already created where I talked about plan resources management pls check that
Thank u sir