(47:57) Sort the results by Order count in descending order. Why you have not used sorter transformation here ? and i think then rank transformation to find 10 top records
Firstly thanks for this video 🙏 this video helped me complete prerequisite. And regarding REG_REPLACE last symbol is 2 single quotes, you can add space between them if required (eg: ' ') and its not double quotes. Hope this helps
Thank you for vedio. For selecting multiple tables while connecting database (18:07), i tried with shift+down arrow but it is not working. Pls help me how can i select multiple target tables
@@kabirsharma0543 if everything was correct, the rows should be fetched from source table to Target table after passing all the transformations. Pls look once again. Only u can figure it out and fix it.
Hiii , Please help me I m trying to complete the t13 informatica mini project All steps are performed mentioned in above vedio.... Mapping and session is valid , workflow monitor also shows succed but record not updated in super store cleaned data
bro I'm getting error on the first table creation itself. Its showing error in last three lines of the table which I have copy pasted and displaying ORA-00955: name is already used by existing object, could you please help me bro, I have verified it step to step,but couldn't been able to find the cause, I'm new to coding
T15 or T13 What would be the easier choice for wings1 considering I do not have any idea for both so need to study properly for both of them. Please help me to pick the easiest one
@@supriyaverma312 Both have their own difficulty. T13 deals with ETL & Visualisation of data(no need to code, knowledge over the tool is needed) T15 deals with Data analytics and AI on AWS. (Needs to code and have a bit of knowledge on AWS services)
@@VENKATSAI thank you for replying first of all But as I do not have any idea for any one of them What would you suggest I should take I have only 1 month to prepare🥲
@@supriyaverma312 in such scenarios, for this time try T13. Try to learn some basics of Informatica and Tableau. A lot of resources are available on youtube, Udemy, LinkedIn. Make sure it is part of your Unit/BG approved tech track. And complete your Prerequisites before 5th October. Videos were available in our channel, they will help you to clear Prerequisites but not clearing the main exam(you have to learn on your own). If I forget anything,please ask.
@venkatsai Hi as today is the last date for learning completion as well as registration Registration time is uptill 11:59 pm today but no idea about learning completion if i complete it before 11:59 pm today will i be eligibile Also it might take a day to reflect the score in ievolve What should I do please help
@@sri957 make sure to complete all the required courses by today and reflects by end of the day. That's all we can do. If not just fill the registration survey form for the courses which u have completed so far. That's it
@@shreeramparivaar Thanks for coming across my channel. Please leave a Like and Subscribe and share this video with your friends. And Don't forget to learn something before you go for your exam.😅
@@dhanuguravana5665 sorry bro, u have to do it for urself. Pls watch the video and note down the things. Then start doing ur handson. Go with the video if u have any doubts.
@@naveenganta after completing all the prerequisites, now we have the Survey for Wings1 is available, pls fill the survey. U have to attend the MCQ exam for Tech Tracks and Non tech tracks, if u have a good score in MCQs, they will call u for the handson exam of Tech Tracks.
Thankyou for reply. Done with the survey. In mcqs test do we have pass percentage like 75 or 80? And Those Hands-ons are similar with these hands-on or harder than this?
@@VENKATSAI please guide us with your videos in learning for those assessments also. Those we have to attempt on our own your videos will not be there for help😔 at that time.
@venkatsai It’s hard to complete the video in the time frame given as we have to watch your video and do the steps Really not understanding what to do And also in the exam will the question be this lengthy or a bit smaller Will it have only informatica or tableau in the handson Exam or any one among the both
@@sri957 completing the hands-on by looking at the video will be time consuming, I recommend u watch the video first and get an idea about the process. Note down the required steps and start ur handson, switch to video whenever u encounter issues. And in exam the length of the question depends on the difficulty level.
I am currently unallocated,in enterprise search iou is showing as others -parent1, when i was in project it was showing bfsi. am i eligible for this cycle?if eligible i come under which bg to choose relative tech track
@@vaishnavip669 for others group, I think we can go with any track, if u r in project, it is showing some particular BG, The do one thing, pick the track which is mutual in both BFSI and Others. Or pls get some clarity with HR or TD from ur project.
@venkatsai Could you please clarify on the duration of Handson for t13 Will it be 2 hours for 2 questions or do we need to complete both informatica and tableau in one hour. Also can we expect similar pattern like in tableau in mini project the chart type is already mentioned in the problem statement will it be the same in Handson Please help
@@sri957 Hello, U will get 45 mins for each technology. U can perform one after the other. U can expect a Moderate to Tough difficulty in both the technologies. We r not sure with how many tasks will be given.
@@VENKATSAIIn the mock test for tableau it was only 20 minutes and for informatica it was 1hr 30 minutes Can you please help on what type of transformations were asked in informatica and was it very difficult or moderate And also like how many tables were there in informatica and charts in tableau and how many needs to be correct atleast to clear the assessment It would be a great help if you could provide some info on this
Will i still get to write the exam if I enroll in invonnovater assessment with t13 and digital with t15 track ? I am an ninja candidate giving exam for the first time
@@gayatrijami790 if u are an Ninja Candidate, first u should enroll for Digital and clear it. The Innovator program is for the people who cleared the Digital Program. U can choose any tracks of ur interest which are part of ur BG/IOU. And for this November cycle registrations were already closed. So prepare for the next cycle which is May 2025.
Hi bro, Do you think in assessment they will ask any different type of transformation apart from which you used on video? Like lookup transformation or transaction control transformation? Also can you suggest how can we prepare for mcq for informatica? Please do answer 🙏
Hi. While creating the tables I've given incorrect data and ran it, after that I edited correct data and ran it again but its showing error as the 'name is already used by an existing user'. Please help
I got an execution error in the order analysis part where the customer id name was not concatenated, was only showing the ID number and count was also wrong.. Suggest me where I should correct this mistake.
Hi, I am getting workflow doesnot exists error when checking via sample test.. even though i created workflow and got the output. Could you please help regd this..
@@ayushchaubey7013 pls try doing it once again carefully and make a screenshot of Sample score. If it's showing Not Passed at the end, Refresh the frescoplay a couple of times.
@@ayushchaubey7013 there are technical glitches. It showed me failed many times, what I did is refreshing it a couple of times after showing as Failed.
I think you will encounter that error when u make all transformations without creating a mapping. Pls check whether u have created a mapping or not. Every series of transformations should be in a mapping, on that mapping u can create workflow,sessions and all. Pls check them once again, take ur time. If you still face the same issue, just submit that session and start a fresh one after sometime.
@@arunpandian5100 Refresh the window 2,3 times, Click on MY courses in fresco, them click on informatica, click on 'Go to Handson',(don't launch for handson), it has to show it as PASSED now. Try refreshing again.
@@sanyuktapatil2295 sorry for delayed response, Next time when you face such an issue, Make sure all the objects u r creating were as per Naming conventions so u don't mismatch anywhere.
Sir, I have completed all the steps you told for first target table results and all results were valid and showing same outputs but when i checked in second table for cust_id_name , this column was not present... Can you please tell what I can do for this?
Bro I need to complete informatica only in t13 and rest are completed, and today is the lastdate to complete nontechtrack right, so is there any possibility to complete it as some are saying that it will take 24 hrs to update in portal
Today is the last date for NON-UNIT SPECIFIC TECH TRACKS, not for Non Tech Tracks. After successfully completing it don't worry about updation in iEvolve,.as today ievolve will encounter a lot of traffic, it will definitely have a delay in updation. Just take a screenshot of ur completion status, that will help u to address future issues.
@@-NeelimaPravallika as per the instructions, we don't need Customer_ID and Customer_Name columns in cleaned data. So we dropped them considering unnecessary. U can refer to the problem statement.
@@bharat8793 actually am not good at coding brother. I can try to make a video, But when u people encounter any errors, I can't help u. And am not sure whether completing any one part is T15 is enough to complete that Hands-on.
@@babuji6441 after successful completion, of it is still showing as failed, Pls refresh it a couple of times and try to keep the ievolve tab active in background . That may work
@@subhojitdas7332 Yes, instructions will be given neatly just like this as in the hands-on in the problem statement, We can't be sure about the toughness of the exam.
@@FYI13 pls save the work and try, If it is failing,.there could be some error somewhere, pls check it slowly. And don't forget to refresh before submitting.
@@babu45252 Thanks for coming across my channel. Please Subscribe and leave a Like, share this video with your friends. And Don't forget to learn something before you go for your exam.😅
@@Amisha_mishra01 I feel you have joined the Telegram group, pls post your query there,snapshot of the issue, that may help me to know the issue and help you with something.
@@ramyachepuri4434 u have the Number of Records in Properties of Rank transformations, change the value to 10 from 1. It will fetch 10 records. And use the truncate option, so it will erase the previous data in the table and update it with fresh data after starting the workflow
Do u mean the affected rows are Zero. If this is the error, u may have done some mistake while transforming or mapping or if you have not properly linked the Source and Target Tables. Pls check the entire workflow thoroughly and slowly,take ur time.
@@ayansen6395 Thankful to your time and appreciation. Please do subscribe and like the video, Share it with your friends who are yet to complete this course. Thanks Again.
@@aslamnavas5525 this time while trying pls try to keep iEvolve active, Take a screenshot of the Sample score. After submitting if it shows as Failed, refresh it a couple of times it may reflect as Pass.
@@Parodyworld00 just drop the course, and re-enroll after some time. I hope it will work. U can also go through my iEvolve playlist, where u can find answers for that assesment. th-cam.com/play/PL6x-boJ_UxTxcgKkMzJ9m2dPGA1wUIU5_.html&si=YIMDhGOt-XoEcNWp
@@Parodyworld00 It has to Work, Try doing it after some 24hours, if not try raising a ticket, you will find HELP button at the bottom of iEvolve page. They may help u with something...
Hi bro,Thank you for this video... I'm preparing for the handson exam using this video. I saw one comment that we should complete the exam in 45 mins. Can we able to complete the exam in 45 mins?
@@akhilaravikiran Hello, I am not familiar with AWS much. I am trying to do that. I will definitely make a video post completion with proper explanation. Please share this T13 video with your friends who selected this course. This will help them.
For learning, you have them in iEvolve itself or you can use TH-cam as well. There are a lot of resources available. About the coding part you should have some idea on SQL. that will help.
@@VENKATSAI thanks for the reply can you suggest any channel or playlist on youtube which would be enough to cover t13 informatica syllabus….it would be very helpful
@@yatishsrinivas1920 pls don't leave the page, Try Refreshing a couple of times, Click on courses and open this course and click on hands-on(don't launch it) and then refresh again. If it's not working, u have to do it again. If u are doing hands-on again, Pls do it after 10-15 mins. Not immediately.
(47:57) Sort the results by Order count in descending order. Why you have not used sorter transformation here ? and i think then rank transformation to find 10 top records
When i create mapping order analysis and after that when i create task , order analysis was not showed in mapping pls advise what i missed
Firstly thanks for this video 🙏 this video helped me complete prerequisite. And regarding REG_REPLACE last symbol is 2 single quotes, you can add space between them if required (eg: ' ') and its not double quotes. Hope this helps
@@shaliniyanamala8824 thanks for commenting 😀.
Yes,those are 2 single quotes, not a double quote...
U made this instruction a bit clear. Thanks again.
Thank you
Thanks for letting us know about double quotes
@@shrutisingh5115 welcome
How completed its taking so much time
Thank you for vedio.
For selecting multiple tables while connecting database (18:07), i tried with shift+down arrow but it is not working.
Pls help me how can i select multiple target tables
@@Chinnu5108 if it's not working, don't worry, try CTRL while selecting.
If it is also not working,
Try importing tables one after the other.
Try with CTRL it is working
I am facing parsing error in 25:10 while I am copying each and everything written here
What error are you getting.
@@VENKATSAI Parsing error execution.... can't recall the full error message
Same error I am aslo facing
Use single quotes two time (‘ and ‘)
@@VENKATSAIfacing the same error
Thank you bro , cleared it with your help✌️
Thanks bro ... this is work of god.😄😄😄
Welcome 😊
Can you help me to complete t13
@@arpitagarwal3001 pls join this t.me/davincicursed
32:30 it shows0 in affected rows, I have checked everything
@@kabirsharma0543 if everything was correct, the rows should be fetched from source table to Target table after passing all the transformations. Pls look once again. Only u can figure it out and fix it.
Are you able to fix it?
Same for me @@VENKATSAI
@kabirsharma0543 were you able to fix it? if yes, then how? I am facing same issue
Thank you so much for sharing the step by step process in detail ❤
Informative and great outcome thanks👍👍
Hiii ,
Please help me
I m trying to complete the t13 informatica mini project
All steps are performed mentioned in above vedio....
Mapping and session is valid , workflow monitor also shows succed but record not updated in super store cleaned data
@@SmilingCrescentMoon-rr8gq sorry for delayed response,
Pls check for all the connections in workflow manager.
32:14 here,session cleaned data is showing as failed instead of getting successful. Why?
@@Vishalkumar_A there could be any error in ur workflow or somewhere,
Pls check them and save the work and then run the workflow again.
bro I'm getting error on the first table creation itself. Its showing error in last three lines of the table which I have copy pasted and displaying ORA-00955: name is already used by existing object, could you please help me bro, I have verified it step to step,but couldn't been able to find the cause, I'm new to coding
@@srinathtamirisa4617 don't worry bro, just look carefully with all commas,brackets and other syntax. Try once again.
I am also facing the same error.Could you please help to solve this
Just try to refresh the tables and confirm whether the table is reflecting or not.
Most probably you are adding the comma "," in the last line as well.
After Sales Int
I am also getting error for creating table
T15 or T13
What would be the easier choice for wings1 considering I do not have any idea for both so need to study properly for both of them.
Please help me to pick the easiest one
@@supriyaverma312 Both have their own difficulty.
T13 deals with ETL & Visualisation of data(no need to code, knowledge over the tool is needed)
T15 deals with Data analytics and AI on AWS. (Needs to code and have a bit of knowledge on AWS services)
@@VENKATSAI thank you for replying first of all
But as I do not have any idea for any one of them
What would you suggest I should take
I have only 1 month to prepare🥲
@@supriyaverma312 in such scenarios, for this time try T13.
Try to learn some basics of Informatica and Tableau. A lot of resources are available on youtube, Udemy, LinkedIn.
Make sure it is part of your Unit/BG approved tech track.
And complete your Prerequisites before 5th October. Videos were available in our channel, they will help you to clear Prerequisites but not clearing the main exam(you have to learn on your own).
If I forget anything,please ask.
@@VENKATSAI okay thank you so much for your advice. I will keep your advice in mind and then choose accordingly. Thanks for your time.
@@supriyaverma312 always... ☺️
Thank you so much friend, I just completed 😊
@@atul06378 welcome 🤗
Thank you for making this video brother
@venkatsai Hi as today is the last date for learning completion as well as registration
Registration time is uptill 11:59 pm today but no idea about learning completion if i complete it before 11:59 pm today will i be eligibile
Also it might take a day to reflect the score in ievolve
What should I do please help
@@sri957 make sure to complete all the required courses by today and reflects by end of the day.
That's all we can do.
If not just fill the registration survey form for the courses which u have completed so far. That's it
@@VENKATSAI I will surely complete but I’m not sure if it reflects immediately in ievolve
In that case will they consider it
Thank you 🙏🙏 bhai this video help me a lot
Thank you.
For errors you can cross check the output in the video vs yours
Also does rhe cycle dates even extend .. like last enrollment dates ?
@@gayatrijami790 so far I don't think the enrolment dates were extended.
Thank you. I cleared the hands on with the help of this video.
@@shreeramparivaar
Thanks for coming across my channel.
Please leave a Like and Subscribe and share this video with your friends.
And Don't forget to learn something before you go for your exam.😅
Hii bro i am try to complete sa mant days but not done could you please help me...
@@dhanuguravana5665 sorry bro, u have to do it for urself.
Pls watch the video and note down the things. Then start doing ur handson.
Go with the video if u have any doubts.
Bro can u guide me
After completing this what next for digital?
Inperson assessment or is there any assessments in middle?
@@naveenganta after completing all the prerequisites, now we have the Survey for Wings1 is available, pls fill the survey.
U have to attend the MCQ exam for Tech Tracks and Non tech tracks, if u have a good score in MCQs, they will call u for the handson exam of Tech Tracks.
Thankyou for reply.
Done with the survey.
In mcqs test do we have pass percentage like 75 or 80?
And Those Hands-ons are similar with these hands-on or harder than this?
@@naveenganta MCQs is percentile basis.
They will pick top associates with some reference score.
U can expect moderate difficulty in Handson.
@@VENKATSAI please guide us with your videos in learning for those assessments also.
Those we have to attempt on our own your videos will not be there for help😔 at that time.
@@VENKATSAI is there any other track without hands-on?
Hi bro, just have some few doubts about t13 examination, what will be the pattern and os there you have given exam on this t13 only right?
Thank you so much for this content
@venkatsai It’s hard to complete the video in the time frame given as we have to watch your video and do the steps
Really not understanding what to do
And also in the exam will the question be this lengthy or a bit smaller
Will it have only informatica or tableau in the handson Exam or any one among the both
You are right, I just exhausted my 2nd attempt. Also, you should have completed these earlier, you lazy fool.
@@sri957 completing the hands-on by looking at the video will be time consuming,
I recommend u watch the video first and get an idea about the process. Note down the required steps and start ur handson, switch to video whenever u encounter issues.
And in exam the length of the question depends on the difficulty level.
@@sri957 u will have to perform handson for both,
Informatica and Tableau both separately.
@@VENKATSAI in the exam are we gonna have both tableau and informatica or any one?
And also among t12 and t13 which will be easier
@@sri957 in exam u will have both.
I don't have any idea about T12
Thank you. It's very helpful
@@keerthipatnayakuni814 Thank you. Please share this with your friends, so they can also complete their prerequisites on time.
Thanks again.
I am currently unallocated,in enterprise search iou is showing as others -parent1, when i was in project it was showing bfsi. am i eligible for this cycle?if eligible i come under which bg to choose relative tech track
@@vaishnavip669 for others group, I think we can go with any track, if u r in project, it is showing some particular BG,
The do one thing, pick the track which is mutual in both BFSI and Others.
Or pls get some clarity with HR or TD from ur project.
Thanks a lot bro finally i have completed the handson using this video❤🎉
@@loki5512 thanks for coming across my content.
Pls share this video with ur friends,so they can also complete the hands-on before the cutoff dates.
@@VENKATSAIyeah I already shared. To my friends. Also if u have any material for informatica and tableau please made videos as well
@@loki5512 I will try, I was already packed with other works aswell.
@venkatsai Could you please clarify on the duration of Handson for t13
Will it be 2 hours for 2 questions or do we need to complete both informatica and tableau in one hour.
Also can we expect similar pattern like in tableau in mini project the chart type is already mentioned in the problem statement will it be the same in Handson
Please help
@@sri957 Hello,
U will get 45 mins for each technology.
U can perform one after the other.
U can expect a Moderate to Tough difficulty in both the technologies.
We r not sure with how many tasks will be given.
@@VENKATSAIThankyou so much for the quick response
Have been a great help throughout the wings journey
Really appreciate your work
@@sri957 thank you brother.
But it is given that we have 2 hours time?
@@VENKATSAIIn the mock test for tableau it was only 20 minutes and for informatica it was 1hr 30 minutes
Can you please help on what type of transformations were asked in informatica and was it very difficult or moderate
And also like how many tables were there in informatica and charts in tableau and how many needs to be correct atleast to clear the assessment
It would be a great help if you could provide some info on this
Thank you man❤️🙏
Hello, how you are selecting multiple tables in the informatica designer after connecting the database
@@udayanilraj211 mutliple tables or mutliple columns in those transformations.! I couldn't get u properly.
Is group 7: assessment mandatory? It shoes complete 23 but we have to do only our track right?
I couldn't get u. Can u pls elaborate
Will i still get to write the exam if I enroll in invonnovater assessment with t13 and digital with t15 track ? I am an ninja candidate giving exam for the first time
@@gayatrijami790 if u are an Ninja Candidate, first u should enroll for Digital and clear it. The Innovator program is for the people who cleared the Digital Program.
U can choose any tracks of ur interest which are part of ur BG/IOU.
And for this November cycle registrations were already closed.
So prepare for the next cycle which is May 2025.
Hi bro,
Do you think in assessment they will ask any different type of transformation apart from which you used on video? Like lookup transformation or transaction control transformation?
Also can you suggest how can we prepare for mcq for informatica?
Please do answer 🙏
@@Vicky-sw5lq that depends on the difficulty of the exam.
While appearing for physical examination, do we get a similar problem statement document.
@@siddheshkulkarni9562 Similar problem statement, with detailed instructions. Time for that hands-on is 45 mins.
@@VENKATSAI Ok. Thank you.
@@VENKATSAI45 minutes for only informatica or for both together informatica and tableau
When i check using sample test after all task it is showing workflow not found
Hi. While creating the tables I've given incorrect data and ran it, after that I edited correct data and ran it again but its showing error as the 'name is already used by an existing user'. Please help
@@priyankapinipe6545 better submit this session and start new one.
The environment sometimes does not reflect the data properly after corrections.
@@priyankapinipe6545 from next attempt pls be careful with all the naming conventions.
I got an execution error in the order analysis part where the customer id name was not concatenated, was only showing the ID number and count was also wrong.. Suggest me where I should correct this mistake.
@@sowmiyajothiram7901 make sure u have created the required columns in all tables, and all required were connected to target tables in each task.
Hi, I am getting workflow doesnot exists error when checking via sample test.. even though i created workflow and got the output. Could you please help regd this..
@@innagandladeepika8622 but when u r getting this error. I mean during executing the workflow or when. Can u pls elaborate.
@@VENKATSAIwhen we check using sample_test at the end of all the tasks..
@@innagandladeepika8622 I am also getting same error please provide solution @venkatsai
@@innagandladeepika8622 if you got any solution for this please let me know how I can remove this error
@@innagandladeepika8622 Is it fixed for you now I'm getting the same error, please help if you have found a solution
I've followed the same instruction as you but how come it was showing 86% to me in the end. Moreover after submitting I got a message of NOT PASSED
@@ayushchaubey7013 pls try doing it once again carefully and make a screenshot of Sample score.
If it's showing Not Passed at the end,
Refresh the frescoplay a couple of times.
@@VENKATSAI sure..what is the passing score of the test? Like it was showing 80% & I already scored 86%.
@@ayushchaubey7013 there are technical glitches. It showed me failed many times, what I did is refreshing it a couple of times after showing as Failed.
@@VENKATSAI Ok I'll try the same.. Thanks for the help.
@@ayushchaubey7013 yeah pls try, best of luck.
Thank you so much bhai 😊
got error while creating a session on workflow manager 'there are no mapping in this folder, create mapping in mapping designer'
I think you will encounter that error when u make all transformations without creating a mapping.
Pls check whether u have created a mapping or not. Every series of transformations should be in a mapping, on that mapping u can create workflow,sessions and all.
Pls check them once again, take ur time.
If you still face the same issue, just submit that session and start a fresh one after sometime.
Please help me
I'm very tired,I also tried many times but record not updated only succeed status shows
Will there be any coding related questions in main exam?.
If not what will be the pattern in main exam
I got 100% in sample test but in fresco play it show as failed, what can i do now?
@@arunpandian5100 Refresh the window 2,3 times,
Click on MY courses in fresco, them click on informatica, click on 'Go to Handson',(don't launch for handson), it has to show it as PASSED now. Try refreshing again.
Bro, When I'm trying to run, it says 'name is already used by an existing object' what to do in this case? Please reply
@@sanyuktapatil2295 sorry for delayed response,
Next time when you face such an issue,
Make sure all the objects u r creating were as per Naming conventions so u don't mismatch anywhere.
Sir, I have completed all the steps you told for first target table results and all results were valid and showing same outputs but when i checked in second table for cust_id_name , this column was not present...
Can you please tell what I can do for this?
Pls verify, whether u have connected those columns properly between all transformations in mapping.
Yes, i have verified 3 time all the mapping is same as shown
Then check the table once, have u created that column or missed it.
@@mansigarg9948 t.me/davincicursed pls join here and post you issue.
@@mansigarg9948 Same issue
When importing the super store data it is showing "server errors must be corrected before proceeding"
@@Sureshemandi where u were facing this error.
same here yaar pls help
Hii bro while cleaning data only one row added in the target table ..I have checked everything but still i couldn't not found the issue
@@sharadsambare7764 sorry for delayed response, only u can check where the issue is. Pls take ur time.
Bro I need to complete informatica only in t13 and rest are completed, and today is the lastdate to complete nontechtrack right, so is there any possibility to complete it as some are saying that it will take 24 hrs to update in portal
Today is the last date for NON-UNIT SPECIFIC TECH TRACKS, not for Non Tech Tracks.
After successfully completing it don't worry about updation in iEvolve,.as today ievolve will encounter a lot of traffic, it will definitely have a delay in updation.
Just take a screenshot of ur completion status, that will help u to address future issues.
Thanks Bro.
I got 86 then again 86 then 93 then finally in the end I got 100%.
@@TCSer is ur handson successfully completed.?
While submitting the course at end it will take so much time to reflect the score
@@boyamadhu9760 it's normal. Just refresh a few times.
thank you so much
Bro y we use count * in the last can anyone explain??
I didn't get any error all Mapping n flow got passed got 86% but result showing you're failed, why?
@@jemimajudith3629 most of the associates are facing this issue,
I don't know why it's like that.
All good at my end and still showing 64%
@@FYI13 if u have submitted.
All we can do is attempting it once again.
Hii bro..my course was completed but it will not show successful in the i evolve... what should I do bro
@@dhanuguravana5665 not showing in the sense, i don't understand
Thanks bhai for the video
Hi I am getting invalid table name error for the first table. Not sure what is wrong
t.me/davincicursed pls.post ur query in the group.
I need more hands-on questions to practice for wings exam
Facing invalid token issue while giving formula
@@anuraghvv1876 which formula
In 38:54
@@aswin9613 what's the error u r getting.
Can u define
Im getting sql error ora-00911 invalid character. At starting itself.
@@arvimahii5757 pls check the syntax of SQL statements u have given.
In wings exam hands on question level will be same ?
@@64tusharraghuvanshi96 could be a bit moderate
Helo i got the score 100 in the lab .. but it still said. . i didn't pass what should i do ?
bro not able to cpy the code from problem statement and can you pls let me know what is feasible way
Try to double click on it,
U could see the cursor symbol,then you can select and copy the content.
Bro you should have used sorter transformation before aggregator in the 4th task
Can you please create a video on how to prepare for t13 to clear the exam
What was the formula to concatenate vnum and customer name..i am not able see Clearly in video anybody help
Why did you remove customer ID column while creating super_store_cleaned_data table
@@-NeelimaPravallika as per the instructions, we don't need Customer_ID and Customer_Name columns in cleaned data. So we dropped them considering unnecessary.
U can refer to the problem statement.
@@VENKATSAI yeah understood and thank you so much for this video bro
Please try to upload T15 handson also as you said u will upload soon. Many of us are eagerly waiting for that😊
@@bharat8793 actually am not good at coding brother. I can try to make a video,
But when u people encounter any errors, I can't help u.
And am not sure whether completing any one part is T15 is enough to complete that Hands-on.
After getting 100 percentage still it's showing not passed. What to do guys please let me know
@@babuji6441 after successful completion, of it is still showing as failed,
Pls refresh it a couple of times and try to keep the ievolve tab active in background . That may work
Are all these instructions will be available during real exam? And the questions will be of this same level or higher?
@@subhojitdas7332 Yes, instructions will be given neatly just like this as in the hands-on in the problem statement,
We can't be sure about the toughness of the exam.
@@VENKATSAI ok thanks for the quick support bro.. keep up the good work.❤️
@@subhojitdas7332 thank you ☺️
I’ve completed this but why the workflow is failing everything works fine
But it’s showing score 64%
Please help me what i did wrong?
It showing work flow not found while run the testing script
@@FYI13 pls save the work and try,
If it is failing,.there could be some error somewhere, pls check it slowly.
And don't forget to refresh before submitting.
Every table is correct and data is correct why it,s showing workflow not found
Please hello to identify this
@@FYI13 have u named the workflow correctly.
Getting invalid error for REG_REPLACE command
@@sateeshsatya359 at the end they are 2 single quotes, not one double quote.
In filter transformation 2 i am getting > parse error function cannot resolve operands
TOT_SALES > 3000 AND AVG_SALES > 300
Help me with solution
@@MOHAMMEDANSARM-n9c pls change the datatype of those two ports to Intiger from nstring...
use the operators which are given there only by clicking on them. like AND and > mentioned in the keyboard on screen
@@MOHAMMEDANSARM-n9c pls change the datatype of those both ports to Intiger from nstring.
Thank youu solved
Still showing the same
I am getting error in Reg_replace command, can you please clear that command?
Hey
Use ' ' this instead of "
Thanks for this video
@@babu45252
Thanks for coming across my channel.
Please Subscribe and leave a Like, share this video with your friends.
And Don't forget to learn something before you go for your exam.😅
In designer > mapping>create option is disabled.Please help me 😢
Sorry for the delay, is the issue still there.
When i create showing error invalid 0RA - 00911
@@Amisha_mishra01 I feel you have joined the Telegram group, pls post your query there,snapshot of the issue, that may help me to know the issue and help you with something.
@@VENKATSAI actually first I commented here then get to know about telegram
@@Amisha_mishra01 ok no worries, pls go on with your hands-on. Good luck
Getting 21 records for order analysis but I have given 10 in Ranking transaction
@@ramyachepuri4434 u have the Number of Records in Properties of Rank transformations, change the value to 10 from 1. It will fetch 10 records.
And use the truncate option, so it will erase the previous data in the table and update it with fresh data after starting the workflow
@@VENKATSAI, Thanks for the reply but I have given top 10 only.Let me cross check again.
Thanks even though that case is failed it is completed successfully 🎉
Why it is showing 0 in session after starting the workflow? Please help
Do u mean the affected rows are Zero. If this is the error, u may have done some mistake while transforming or mapping or if you have not properly linked the Source and Target Tables.
Pls check the entire workflow thoroughly and slowly,take ur time.
Ok sure.@@VENKATSAI
Thank you for sharing this video..Appreciate for your help😊🎉
@@ayansen6395 Thankful to your time and appreciation.
Please do subscribe and like the video,
Share it with your friends who are yet to complete this course.
Thanks Again.
I have completed the handson with 100% sample score... But it is showing ad failed
@@aslamnavas5525 this time while trying pls try to keep iEvolve active,
Take a screenshot of the Sample score.
After submitting if it shows as Failed, refresh it a couple of times it may reflect as Pass.
I have completed hands on but in T13 for assessment my attempts are exhausted pls tell how to get more attempts
@@Parodyworld00 just drop the course, and re-enroll after some time. I hope it will work.
U can also go through my iEvolve playlist, where u can find answers for that assesment.
th-cam.com/play/PL6x-boJ_UxTxcgKkMzJ9m2dPGA1wUIU5_.html&si=YIMDhGOt-XoEcNWp
@@VENKATSAI no I tried same thing many times didn’t work
@@Parodyworld00 It has to Work,
Try doing it after some 24hours,
if not try raising a ticket, you will find HELP button at the bottom of iEvolve page. They may help u with something...
@@Parodyworld00 bhai tera hua kya ye problem solve? agar solve hua to batana kaise hua, mera bhi same problem aa rha hai.
@@vinodjairmod6387ha ek or attempt mila course admin ko mail ki thi
Hi bro,Thank you for this video... I'm preparing for the handson exam using this video. I saw one comment that we should complete the exam in 45 mins. Can we able to complete the exam in 45 mins?
It’s showing work flow not found while running the test
And showing sample score 64% and failed
@@FYI13 haven't u saved the work.
Yeah, I’ve saved all the work and workflow was there all the time still showing not found while running the test
@@FYI13 I too got the same score any luck how to check on that
Reg replace giving not integer, only giving the letter part
Can anyone tell is this course come under itis or bps
ITIS
In IT(15205) & ITIS(15206) , we have all these courses available.
All we need to know is whether it is part of our BG/IOU approved.
This also we have done in the Wings 1 exam in centre
I am getting workflow not found for every steps what should I do?
Please provide solution on this
@@bhushanpatil3866 were u not creating workflow or what
For all object it is showing like
Workflow_cleandata not found
Workflows _ geographic not fount like this please give solution
@@bhushanpatil3866 I am unable to know, what's ur error really is.
In sample test file it I showing any workflow not found
@@bhushanpatil3866 u able to complete the entire handson right, without any errors.?
After concatenation also customer-id-name is showing null
@@pragatipradhan9890 make sure all connections were properly given, in workflow manager also source and target connections were given
Hi could you please explain and clear T15 handson
@@akhilaravikiran Hello, I am not familiar with AWS much. I am trying to do that. I will definitely make a video post completion with proper explanation.
Please share this T13 video with your friends who selected this course. This will help them.
hi bro could you please only share the what topic to be covered in t15 curriculum.
@@shubhamkumar-go7rr i don't have any idea about T15 bro
From where can we learn informatica to be able to clear this code without help??please tell
For learning, you have them in iEvolve itself or you can use TH-cam as well. There are a lot of resources available.
About the coding part you should have some idea on SQL. that will help.
@@VENKATSAI thanks for the reply can you suggest any channel or playlist on youtube which would be enough to cover t13 informatica syllabus….it would be very helpful
Bro there is no folder option in powercenter workflow
@@HARISH9243-y2s folder option will be there in repository bro,
The workflow manager is for creating workflows.
Result is not reflecting after successful completion.
@@yatishsrinivas1920 pls don't leave the page,
Try Refreshing a couple of times,
Click on courses and open this course and click on hands-on(don't launch it) and then refresh again.
If it's not working, u have to do it again.
If u are doing hands-on again, Pls do it after 10-15 mins. Not immediately.
REG_REPLACE(CUSTOMER_ID,??
this formula is not clear in video could you please share the formula
24:55
REG_REPLACE(CUSTOMER_ID,'[^0-9]', '')
@VENKATSAI tysm
I am facing error in the formula:
TOT_SALES > 3000 AND AVG_SALES > 300
Error: Function cannot resolve operands of ambiguously mismatching type
@@deepanshusingh325 pls change the datatype of Totsales and avgsales to INTIGER in the previous transformation.
Sample score - 80% is enough to pass the hands on ?
@@vinoth8832 sample is not any parameter to pass/fail,
It's just to check, Sample Score.
Thank you
I couldn't able to complete each time its shows some error. Can anybody pls help me
Hello bro, I will share with you the Telegram channel link, pls join there and post ur query.
t.me/davincicursed
@@VENKATSAI It is a channel, we cannot post or write anything. Better create a group
@@anon3181 sorry, by mistake I have created a channel.
t.me/davincicursed
This is an updated link to join the Telegram group.
When I created table showing error why?
I am getting error at writing the expression Reg_replace even though writing correctly could you please help me
Its Reg_Replace(Customer_ID, '[^0-9]', '')
Please cross-check with every letter, take ur time.
@@VENKATSAIThank you
@@shakeelreddy2949last symbol was double quotes or 2 single quotes , please reply
@@shakeelreddy2949 Hi, the quotes at the end are 2 single quotes,not one double quote.
Try this way once,
REG_REPLACE(Customer_ID, '[^0-9]', ' ').
@@VENKATSAI yes got it