This Blog is all about ETL related Information.It gives information about Datastage ,Informatica,Oracle,SQL,PL/SQL ,Unix,Data warehousing ,Data Modeling and ER Model concepts and FAQ's
Sunday
Informatica Certification FAQ's
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:- Administrator;
- Developer; and
- 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:
|
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:
|
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:
|
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
Wednesday
Datastage DsAdmin Questions
- 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
- How to kill the process? $ ps $kill -9/-1 PID
- 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')
- cd ${INSTALLATION_PATH}/DSEngine/bin
- ./dsenv
- ./uv -admin -stop
- 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')
- What is the command to Restart the DataStage Server? What is UV over there
- 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.
- 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.
- 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.
- 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
- How do you restart the failure job in sequencer using Administrator or Director? Sequence(Add check points on failure)


