Got a question on the topic? Please share it in the comment section below and our experts will answer it for you. For Edureka Informatica Certification Training Curriculum, Visit our Website: bit.ly/2Gw0uML
Hi ! Thank you for taking time to leave us this great review about our channel .Stay connected with us through youtube chanel by subscribing the channel :)Do subscribe our channel and hit that bell icon to never miss an video from our channel . Cheers !
Hey Naveen, thanks for the wonderful feedback! We're glad you found our tutorial useful. You can also check out our complete training here: www.edureka.co/informatica. Do subscribe to our channel to stay posted on upcoming tutorials. Hope this helps. Cheers!
We are super happy that Edureka is helping you learn better. Your support means a lot to us and it motivated us to create even better learning content and courses experience for you . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Thank you so much : ) We are glad to be a part of your learning journey. Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
+Jahme Heru, thanks for checking out our tutorial! We're glad you found it useful. Here's another video that we thought you might like: ua-cam.com/video/KjP3PriNEbI/v-deo.html. You might also find this blog relevant: www.edureka.co/blog/interview-questions/informatica-interview-questions. Do subscribe to our channel to stay posted on upcoming tutorials. Cheers!
Thank you so much : ) We are glad to be a part of your learning journey. Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Excellent video..one question what is the role of informatica or ETL tester? As developer ll be writing mappings and workflows likewise what would be the role of ETL or informatica tester?
An ETL tester is primarily responsible for validating the data sources, extraction of data, applying transformation logic, and loading the data in the target tables. Hope that helps!
You're welcome 😊 Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
in Q.33 you have given same logic for both Odd and Even ports i.e. iff(NEXTVAL % 2)=0,1,0), which should give same result for both Odd and Even ports so all the records will go into only one target. please correct me if i am wrong.
No, the logic is same for both odd and even but we give another condition that is odd=0 for even records and odd=1 for the odd records. When the expression is evaluated it either gives 0 or 1 after that the condition we gave later in router comes into play. odd =1 records the records with odd numbers as generated by the sequence counter odd=0 records the records wth even numbers as generated by sequence counter. Hope this helps :)
Hi Kaliannan, Aggregator transformation is an active transformation is used to performs aggregate calculations like sum, average, etc. The aggregate operations are performed over a group of rows, so a temporary placeholder is required to store all these records and perform the calculations.
Hi Nikhar, When you specify hash auto-keys partitioning in the preceding mapping, the Sorter transformation receives rows of data grouped by the sort key, such as ITEM_DESC. If you select hash user keys partitioning at any partition point, you must specify a hash key.
Got a question on the topic? Please share it in the comment section below and our experts will answer it for you. For Edureka Informatica Certification Training Curriculum, Visit our Website: bit.ly/2Gw0uML
Edureka training videos are always excellent one. Nice work. great effort
Its very good ..
Validating mapping can be done using prep commands using the keyword validate -n mappingname -o mapping -f foldername-s -k -m test
Great session.. very useful..
Thank You 😊 Glad it was helpful!! Keep learning with us..
Excellent session covering all the basics.
Hi ! Thank you for taking time to leave us this great review about our channel .Stay connected with us through youtube chanel by subscribing the channel :)Do subscribe our channel and hit that bell icon to never miss an video from our channel . Cheers !
It's useful.. thankyou
Excellent explanation... I appreciate... thanks ...
Hey Snehal! Thank you for appreciating our work. Do subscribe, like and share to stay connected with us. Cheers :)
Abhishek is really a expert professional. Liked the way he is explaining the logic.
Hey Naveen, thanks for the wonderful feedback! We're glad you found our tutorial useful.
You can also check out our complete training here: www.edureka.co/informatica.
Do subscribe to our channel to stay posted on upcoming tutorials. Hope this helps. Cheers!
Thankyou sir for providing a very good session, it is helpful if you provide the next sessions as well.
Thank you for watching our video. Do subscribe, like and share to stay connected with us. Cheers :)
Really useful .. Thank you
Hey Masila, thank you for watching our video. We are glad to know that you liked our tutorial. Do subscribe and stay connected with us. Cheers :)
Its wonderful
I would like to thank u for this Nice approach.
I would like to thank u for this Nice interview.
We are super happy that Edureka is helping you learn better. Your support means a lot to us and it motivated us to create even better learning content and courses experience for you . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Thank you adureka for bringing up this video and thank you so much host
Thank you so much : ) We are glad to be a part of your learning journey. Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
very useful
Great work! thank you :)
Thank you for watching our video. Do subscribe, like and share to stay connected with us. Cheers :)
Excellent!!!!!
+Jahme Heru, thanks for checking out our tutorial! We're glad you found it useful.
Here's another video that we thought you might like: ua-cam.com/video/KjP3PriNEbI/v-deo.html. You might also find this blog relevant: www.edureka.co/blog/interview-questions/informatica-interview-questions.
Do subscribe to our channel to stay posted on upcoming tutorials. Cheers!
Thank you....
Useful content
Thank you so much : ) We are glad to be a part of your learning journey. Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Wow really superb knowledge sir you have and shared . Thanks much
And thanks much edureka for sharing nice and useful videos
Excellent video..one question what is the role of informatica or ETL tester? As developer ll be writing mappings and workflows likewise what would be the role of ETL or informatica tester?
An ETL tester is primarily responsible for validating the data sources, extraction of data, applying transformation logic, and loading the data in the target tables. Hope that helps!
Thanks for helpng me out to get 150% salary hike. 90 percent of the questions were from this video only
You're welcome 😊 Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
in Q.33 you have given same logic for both Odd and Even ports i.e. iff(NEXTVAL % 2)=0,1,0), which should give same result for both Odd and Even ports so all the records will go into only one target. please correct me if i am wrong.
No, the logic is same for both odd
and even but we give another condition that is odd=0 for
even records and odd=1 for the odd records.
When the expression is evaluated it either gives 0 or 1
after that the condition we gave later in router comes into play.
odd =1 records the records with odd numbers as generated by
the sequence counter
odd=0 records the records wth even numbers as generated
by sequence counter.
Hope this helps :)
perfect
great
Hi Sir
Q39,to my knowledge can we achieve without help of aggregator transformation, why do we need aggregator transformation
Regards
Gowthami
Hi Kaliannan, Aggregator transformation is an active transformation is used to performs aggregate calculations like sum, average, etc. The aggregate operations are performed over a group of rows, so a temporary placeholder is required to store all these records and perform the calculations.
What is the difference between Hash Auto keys partitioning and hash user key partitioning?
Hi Nikhar, When you specify hash auto-keys partitioning in the preceding mapping, the Sorter transformation receives rows of data grouped by the sort key, such as ITEM_DESC. If you select hash user keys partitioning at any partition point, you must specify a hash key.
Great video... thank you so much for helping us 😊😊👍
Excellent
Hey Suresh, thank you for the appreciation! :)