Sunday

Informatica Certification FAQ's

General
  • What do I need to bring with me to my public class? It is being held at an Informatica facility. Nothing. All required learning materials are provided in the classroom.
  • What is the required clothing attire for class attendance? Casual attire is recommended, we want you to be comfortable - however, we ask that you not wear inappropriate T-shirts or cut offs.
  • What time does class start / end? The class start time is indicated and spelled out on your Class Confirmation letter you will receive via e-mail. Typically most Informatica education centers open at 8:30 am (daily) with classes starting at 9:00 am. Classes end approximately at 5:00 pm (daily). There is a lunch break as well as a 15-minute mid-morning break and mid-afternoon break. For additional information, call Global Education Services at 1-866-311-5338, or you can e-mail us at training_registrar@informatica.com.
  • I found the Informatica course I would like to take, but there is not a location close to me on the schedule. For additional information, call Global Education Services at 1-866-311-5338, or you can e-mail us at training_registrar@informatica.com.
  • How do I know that my class has been confirmed? After your payment has been received and the class has been confirmed you will be sent an e-mail Confirmation notification notice.
  • I am having trouble finding the course I need. You can contact Informatica Global Education Services by calling 1-866-311-5338, or by sending an e-mail request for help to training_registrar@informatica.com.
  • Can I buy Informatica Global Education courseware separately? No, Informatica Global Education course materials are not separately for sale. You must attend a class to receive the manuals.
  • I am new to Informatica products, how can I find out what classes I need to take? Plan your Informatica educational path by going to www.informatica.com, choose Services, then choose Education Services, finally choose Curriculum Paths. This will provide several education options.
  • What is On-site Training? In addition to our publicly-scheduled classes, most of our instructor-led courses can be delivered as an on-site class at your location. On-site training events are designed to meet your needs, while reducing the impact on your business and training budget. To request on-site training call Global Education Services at 1-866-311-5338, or you can e-mail us at training_registrar@informatica.com. What is included in a standard on-site event? Typically pricing for an on-site event will include an Informatica instructor, travel and expenses (within the US) all courseware and set up documentation. Payments
  • When do my course fees have to be paid? A form of payment must be received by Global Education Services no later than three business days prior to the first day of class in order to remain in the class and confirm your seat. Failure to provide payment by this date may result in removal from the class, and/or late cancellation fees applied. You can submit payment in the form of a faxed copy of a Purchase Order, check, credit card, or Informatica Pre-Paid Training Credits. Global Education Services fax number is: 614-388-5541
  • What are pre-paid training credits? Training credits may be purchased and applied towards any Informatica Global Education Services' offering, including: Public training courses, on-site training courses, Informatica Virtual Academy, eLearning, and Informatica Professional Certification exams. The cost of training credits depends on the quantity purchased. Training credits are valid for use for one year from the date of purchase. Public Course and IVA Pricing: public courses require 10 training credits per one 8-hour day of instruction. For courses with durations less than one day, the credits are prorated.On-site (Customer Site) Course Pricing: On-site courses require 64 training credits per one 8-hour day of instruction for up to 8 students. Additional students (up to 15 students) are 8 credits per student per day of instruction. The training credit fees cover all course fees and materials, and instructor travel expenses, within the United States. The Customer is responsible for any facility rental charges if class is not held at the Customer's facility. Discount Schedule: Training Credits - Tier 1 (0-99 credits), Price per credit $80 USD (representing a 0% discount) Training Credits - Tier 2 (100-199 credits), Price per credit $76 USD (representing a 5% discount) Training Credits - Tier 3 (200+ credits), Price per credit $72 USD (representing a 10% discount) Bulk Purchases Corporate Pass (384 credits) $26,000 USD (representing a 15% discount) Corporate Pass Plus (768 credits) $48,000 USD (representing a 21%discount)
  • My company has purchased Informatica Pre-paid Training Credits, how do I use them? When registering online the attendee should obtain the purchase credit access key from the designated Credit Administrator. During the on-line registration processes the attendee will be prompted to choose a payment method. Choose "Purchase Credits" and enter the access key in the field provided.
  • Is there sales tax on Global Education courses? Typically, within the United States, sales taxes do not apply to course fees. However, for some international locations sales taxes do apply and the Customer is responsible for determining applicability and for satisfying any taxation requirements. You will want to check with your Accounts Payable department to determine what if any applicable taxes need be accounted for. Cancellation
  • What is the cancellation policy for Informatica Global Education? Requests for cancellations or date transfers need to be received by Informatica Global Education Services at least ten (10) business days prior to the event start date in order to receive a full refund. If a cancellation or reschedule request is received less than ten (10) business days before the start date, the penalty of 100% of the cost of the course will be applied so none of the fee will be refunded. Refunds will not be allowed for "no-shows". This cancellation policy is strictly enforced.
  • What happens if Informatica needs to cancel or reschedule a course? Informatica reserves the right to cancel events for any reason at anytime. Cancellation liability for Informatica if Informatica cancels the course is limited to the return of course payment ONLY. Informatica will not reimburse registrants for any other costs including but not limited to any travel cancellation fees or penalties, including airfare and hotel costs. PLEASE NOTE: If your registration status is either "New", or "In Progress" you have not been confirmed for the class and it is recommended that you do not make any travel arrangements until you have received a confirmation e-mail letting you know the class and registration is confirmed.
  • How will I know if my course has been rescheduled? Informatica Global Education Services reserves the right to reschedule or cancel a course due to low enrollment or if necessitated by other circumstances. Informatica Global Education Services will contact you via e-mail or phone to inform you of the change of schedule. Once you have been notified you may reschedule or receive a full credit. Informatica Global Education Services shall not be liable for any other costs including but not limited to any non-refundable travel arrangements if a course is rescheduled or canceled. Informatica Virtual Academy (IVA)
  • What does IVA stand for? Informatica's Virtual Academy combines the interactivity of instructor-led classroom learning with the comfort and convenience of learning in your customary work environment. The virtual Academy uses Microsoft's "Live Meeting" tool to deliver our expert-led workshops using audio and video right at your desk. With this technology, you can interact with the instructor and other students and ask questions using either audio or text messaging. Labs are supported through Informatica's and Hatsize virtual lab environment, so you don't have to tie up your licenses to complete the hands on experience. Each class is broken into individual modules, each lasting about half a day. Sessions are scheduled frequently and at different times of the day, allowing you to pick the times that are most convenient to you. After you register for a class and your payment is processed, you will receive detailed information about how to access your Virtual Classes, download the materials and connect to the session.
  • Is an IVA class the same format as an E-learning class? No, IVA training is in a Live Meeting format with the instructor on line with you during the entire class, whereas E-learning is a pre-recorded session that can be accessed at any time. E-learning is a self-pace format that must be completed in one year's time.
  • Where can I attend IVA training? You may attend IVA training at a location of your choice; home, office or conference room, as long as you have access to high-speed internet with no firewall, no proxy server and no VPN; and an pen phone line.You will also need internet Explorer 6 or higher, monitor resolution set to 1024 x 768, and a telephone connection with a speaker phone or headset for hands free communication.
  • Will I get courseware with my IVA class? Yes, your courseware will be sent to you either via e-mail in PDF format or via Federal Express depending on the size of the manual.
  • When can I expect the IVA courseware to be shipped / sent? As soon as your registration has been completed all data, paperwork and payments have been processed, and the class has been confirmed. Courseware will be either e-mailed in PDF format or will be sent to the address you provided in your Informatica Global Education on-line profile.
  • Will I need to download or install Informatica software to attend an IVA class? You will need to verify the latest version of JavaScript and possibly download the latest version of software for Microsoft Live Meeting Manager; you will not need to install Informatica software. After registration, an e-mail acknowledgement will be sent to you with test links for these downloads. Courtesy:informatica.com
  • Tuesday

    Informatica Professional Certification Program

    In this competitive IT market place, you need to differentiate yourself. Demonstrate your technical ability by becoming an Informatica Certified Professional.

    Informatica Professional Certification proves you have the knowledge and skills needed to meet today’s complex data integration challenges. You will be recognized among the elite Informatica users who possess the technical know-how and ability to design, implement, use, and support the Informatica solution. In addition, the Informatica Certification Program provides an objective measurement for benchmarking and validating technical Informatica product expertise.


    By being Informatica certified, you established your professional credibility with your employer and within the competitive IT industry. These tangible, industry-recognized credentials can help you succeed in your career, improve your productivity, and increase your marketability.
    Take your expertise to the next level with the Informatica Professional Certification.

    There are three levels of certifications available:
    1. Administrator;
    2. Developer; and
    3. Consultant
    Certification Level Number of Exams Required Description
     Informatica Certified Administrator For PowerCenter administrators, testers, and project managers you need to attain a passing score (70 percent or higher) on two exams:
    1. Architecture and Administration
    2. Advanced Administration
    Administrator. Become an specialist in managing and maintaining the infrastructure of platform integration projects
     Informatica Certified Developer For PowerCenter transformation, mapping, and mapplet developers, you need to attain a passing score on three exams:
    1. Architecture and Administration
    2. Mapping Design
    3. Advanced Mapping Design
    Developer. Become an specialist in developing, troubleshooting and maintaining transformations, mappings, and mapplets
     Informatica Certified Consultant For PowerCenter experts you need to attain a passing score on five exams:
    1. Architecture and Administration
    2. Mapping Design
    3. Advanced Administration
    4. Advanced Mapping Design
    5. Enablement Technologies.
    Consultant. Become a true data integration expert by meeting the criteria of both an Informatica Certified Administrator and Designer

    An Informatica Professional Certification is based strictly on knowledge level you can attain through a combination of hands-on project work and Informatica training. Before taking an exam, Informatica provides you with a Skill Set Inventory to ensure that you have a detailed understanding of every topic that will be covered in a particular exam. All exams are multiple choice and administered over the Web.
    Learn more about the Informatica Professional Certification exams by reading the FAQ here

    Datastage DsAdmin Questions related to Unix

    1. List the files in current directory sorted by size ? - ls -l | grep ^- | sort -nr
    2. List the hidden files in current directory ? - ls -a1 | grep "^\."
    3. Delete blank lines in a file ? - cat sample.txt | grep -v ‘^$’ > new_sample.txt
    4. Search for a sample string in particular files ? - grep .Debug. *.confHere grep uses the string .Debug. to search in all files with extension..conf. under current directory.
    5. Display the last newly appending lines of a file during appendingdata to the same file by some processes ? - tail .f Debug.logHere tail shows the newly appended data into Debug.log by some processes/user.
    6. Display the Disk Usage of file sizes under each directory in currentDirectory ? - du -k * | sort .nr (or) du .k . | sort -nr
    7. Change to a directory, which is having very long name ? - cd CDMA_3X_GEN*Here original directory name is . .CDMA_3X_GENERATION_DATA..
    8. Display the all files recursively with path under current directory ? - find . -depth -print
    9. Set the Display automatically for the current new user ? - export DISPLAY=`eval ‘who am i | cut -d"(" -f2 | cut -d")" -f1′`Here in above command, see single quote, double quote, grave ascent is used. Observe carefully.
    10. Display the processes, which are running under yourusername ? - ps .aef | grep MaheshvjHere, Maheshvj is the username.
    11. List some Hot Keys for bash shell ? - Ctrl+l . Clears the Screen. Ctrl+r . Does a search in previously given commands in shell. Ctrl+u - Clears the typing before the hotkey. Ctrl+a . Places cursor at the beginning of the command at shell. Ctrl+e . Places cursor at the end of the command at shell. Ctrl+d . Kills the shell. Ctrl+z . Places the currently running process into background.
    12. Display the files in the directory by file size ? - ls .ltr | sort .nr .k 5
    13. How to save man pages to a file ? - man | col .b > Example : man top | col .b > top_help.txt
    14. How to know the date & time for . when script is executed ? - Add the following script line in shell script.eval echo "Script is executed at `date`" >> timeinfo.infHere, .timeinfo.inf. contains date & time details ie., when script is executed and history related to execution.
    15. How do you find out drive statistics ? - iostat -E
    16. Display disk usage in Kilobytes ? - du -k
    17. Display top ten largest files/directories ? - du -sk * | sort -nr | head
    18. How much space is used for users in kilobytes ? - quot -af
    19. How to create null file ? - cat /dev/null > filename1
    20. Access common commands quicker ? - ps -ef | grep -i $@
    21. Display the page size of memory ? - pagesize -a
    22. Display Ethernet Address arp table ? - arp -a
    23. Display the no.of active established connections to localhost ? - netstat -a | grep EST
    24. Display the state of interfaces used for TCP/IP traffice ? - netstat -i
    25. Display the parent/child tree of a process ? - ptree Example: ptree 1267
    26. Show the working directory of a process ? - pwdx Example: pwdx 1267
    27. Display the processes current open files ? - pfiles Example: pfiles 1267
    28. Display the inter-process communication facility status ? - ipcs
    29. Display the top most process utilizing most CPU ? - top .b 1
    30. Alternative for top command ? - prstat -a

    Wednesday

    Datastage DsAdmin Questions

    1. Have you created User groups and Users? $ group -c ourgroup $ group -m groupname userid $ group -o groupname userid $ group -O groupname userid # adduser --ingroup grname userid
    2. How to kill the process? $ ps $kill -9/-1 PID
    3. How to Unlock DataStage Jobs if the job is used by the another user or Hanged out?

      su - dsadm {enter your password for dsadm, else you can use root} cd `cat /.dshome` . ./dsenv bin/uvsh list.readu {find the row that shows your lock, look over to the USERNO column and get that number} UNLOCK USER nnnnn ALL QUIT

      • CD To $DSHOME/../Projects/ProjectName
      • Type the Following and press Enger. INSERT INTO VOC (F0, F1, F2, F3, F4, F5) VALUES ('UNLOCK','V', 'list_readu','E','BV','unlock')
        1. cd ${INSTALLATION_PATH}/DSEngine/bin
        2. ./dsenv
        3. ./uv -admin -stop
    4. How to Add Unlock command to Vocabulary file(VOC)? CD To $DSHOME/../Projects/ProjectName INSERT INTO VOC (F0, F1, F2, F3, F4, F5) VALUES ('UNLOCK','V', 'list_readu','E','BV','unlock')
    5. What is the command to Restart the DataStage Server? What is UV over there
    6. Tell me some problems you may encounter when the DataStage running on UNIX platforms? 1. Running out of file units, 2. Running out of memory(Heap error), 3. open connection, 4. ODBC connection problems.
    7. What is Heap Error? Anything to do with "heap" is about allocation of memory resources. Either install more memory in your server(s), or reduce overall demand for memory, perhaps by running less no. of jobs simultaneously, or by running on a configuration with less no. of processing nodes.
    8. What happens when you shut down the Datastage server without closing all client connections? There may be an open connection from a Datastage client, Without shutting down the client processes, sockets are released on most platforms after the timeout period of about 6 - 10 minutes, depending on system tuning.
    9. Which command is used to know whether the datastage server is running or not? ps -ef | grep dsrpc (this process should not be running when DataStage has stopped successfully) OR #netstat | grep dsrpcd
    10. How do you restart the failure job in sequencer using Administrator or Director? Sequence(Add check points on failure)