Informatica Interview Questions | Informatica Tutorial | Informatica Training | Edureka
HTML-код
- Опубликовано: 20 фев 2017
- ( Informatica Tutorial - www.edureka.co/informatica-ce... )
This Edureka Informatica training will help you to prepare yourself for Informatica Interviews ( Informatica Interview Questions Blog: goo.gl/z4jVff ). Learn about the most important Informatica interview questions and answers and know what will set you apart in the interview process. Below are the topics covered in this Informatica Interview Questions and Answers Tutorial:
Informatica Interview Questions on:
1. Generic Informatica Interview Questions.
2. Informatica Transformation Questions.
3. Informatica Lookup Questions.
4. Informatica Scenario Based questions.
5. Informatica Workflow Questions.
6. Informatica Administrator Questions
Check our Informatica playlist here goo.gl/TmX6Fv.
Other Related Blog Post:
goo.gl/tq8qBu
goo.gl/ey7YMC
goo.gl/bUFckp
goo.gl/c6ttKu
Subscribe to our channel to get video updates. Hit the subscribe button above.
#Informatica #Informaticatutorial #Informaticapowercenter #Informaticaonlinetraining
How it Works?
1. This is a 6 Week Instructor led Online Course, 25 hours of assignment and 20 hours of project work
2. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course.
3. At the end of the training you will be working on a real time project for which we will provide you a Grade and a Verifiable Certificate!
- - - - - - - - - - - - - - - - -
About the Course
Edureka's Informatica PowerCenter Certification training is designed to help you become a top Informatica Developer and Administrator. During this course, our expert Informatica instructors will help you:
1. Understand and identify different Informatica Products
2. Describe Informatica PowerCenter architecture & its different components
3. Use PowerCenter 9.x components to build Mappings, Tasks, Workflows
4. Describe the basic and advanced features functionalities of PowerCenter 9.X transformations
5. Understand Workflow Task and job handling
6. Describe Mapping Parameter and Variables
7. Perform debugging, troubleshooting, error handling and recovery
8. Learn to calculate cache requirement and implement session cache
9. Execute performance tuning and Optimisation
10. Recognise and explain the functionalities of the Repository Manager tool.
11. Identify how to handle services in the Administration Console
12. Understand techniques of SCD, XML Processing, Partitioning, Constraint based loading and Incremental Aggregation
13. Gain insight on ETL best practices using Informatica
- - - - - - - - - - - - - - - - - - -
Who should go for this course?
The following professionals can go for this course :
1. Software Developers
2. Analytics Professionals
3. BI/ETL/DW Professionals
4. Mainframe developers and Architects
5. Individual Contributors in the field of Enterprise Business Intelligence
- - - - - - - - - - - - - - - -
Why learn Informatica?
Informatica provides the market's leading data integration platform. Tested on nearly 500,000 combinations of platforms and applications, the data integration platform interoperates with the broadest possible range of disparate standards, systems, and applications. This unbiased and universal view makes Informatica unique in today's market as a leader in the data integration platform. It also makes Informatica the ideal strategic platform for companies looking to solve data integration issues of any size.
The topics related to Informatica have extensively been covered in our course 'Informatica PowerCenter 9.X Developer & Admin’.
For more information, Please write back to us at sales@edureka.co or call us at IND: 9606058406 / US: 18338555775 (toll free).
Facebook: / edurekain
Twitter: / edurekain
LinkedIn: / edureka
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
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
Edureka training videos are always excellent one. Nice work. great effort
Great video... thank you so much for helping us 😊😊👍
Its wonderful
Thank you....
very useful
I would like to thank u for this Nice approach.
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 :)
It's useful.. thankyou
perfect
Excellent explanation... I appreciate... thanks ...
Hey Snehal! Thank you for appreciating our work. 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 :)
great
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: ruclips.net/video/KjP3PriNEbI/видео.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!
Great work! thank you :)
Thank you for watching our video. Do subscribe, like and share to stay connected with us. Cheers :)
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 !
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!
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 :)
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!
Excellent
Hey Suresh, thank you for the appreciation! :)
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 : )
Great session.. very useful..
Thank You 😊 Glad it was helpful!! Keep learning with us..
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
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.
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 : )
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.