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
	For PowerCenter administrators, testers, and project managers you need to attain a passing score (70 percent or higher) on two exams: Architecture and Administration Advanced Administration	Administrator. Become an specialist in managing and maintaining the infrastructure of platform integration projects
	For PowerCenter transformation, mapping, and mapplet developers, you need to attain a passing score on three exams: Architecture and Administration Mapping Design Advanced Mapping Design	Developer. Become an specialist in developing, troubleshooting and maintaining transformations, mappings, and mapplets
	For PowerCenter experts you need to attain a passing score on five exams: Architecture and Administration Mapping Design Advanced Administration Advanced Mapping Design 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

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)