QUESTIONS
When the power center server loads IBM DB2 the session fails when you use a database partition type on Numeric column
Answer: False
QUESTIONS
As400 table columns larger the 4000bytes will truncate(T/F)
Answer: False
QUESTIONS
Choose which one is false?
Answer: A valid workflow can be scheduled from workflow->edit option
QUESTIONS
Are loops supported in workflows?
Answer: No
QUESTIONS
The workflow manager receives notification messages from _____________.
Answer: repository server
QUESTIONS
Remember all the information that is attached to object shortcut. I cant remeber the exact question but you must get question shortcut.
Answer: The name of the user who created the short cut
QUESTIONS
What are Informatica data movement modes?
Answer: Ascii and Unicode
QUESTIONS
The repository server must be running before a repository is created - True/False?
Answer: x
QUESTIONS
I have got one question on Where can you create workflow tasks?
Answer: in the task developer, the workflow designer, the worklet designer
QUESTIONS
There will be 4 options.You have to select one option regarding the activity that is performed by Repository Manager.
Answer: Create folders, validate mappings and mapplets, create repository users
QUESTIONS
If you concatenate data from a normalizer transformation the ports concatenated cannot contain occurs
Answer: this is a known limitation in V7
QUESTIONS
If there is no space in the systema and you are going to save a large mapping then what will happen?
Answer: Informatica will shut down unexpectedly.
QUESTIONS
In a workflow manager you can create a session
Answer: by creating a task in the task developer.
QUESTIONS
Select the false statement.
Answer: Workflows must be within tasks to be executed
QUESTIONS
2 servers are registered to a repository. Say an existing workflow runs on Server A. What is required to run the same workflow on Server B
Answer: edit the workflow properties.
QUESTIONS
What happens if a user attempts to delete the owner of a connection object?
Answer: The workflow manager automatically assigns the ownership to the administrator user.
QUESTIONS
What is the definition of a local shortcut?
Answer: A shortcut to an object in the same repository
QUESTIONS
What privileges are required to an user to open a foler?
Answer: Does not have write permissions on the folder
QUESTIONS
Mug up all the operations that can be performed using pmrep command.You must get a question on that.
Select the operation that is not available in the pmrep command?
Answer: Change the password expiration date of a user
QUESTIONS
Which of the following is not a type of workflow task?
Answer: Mapping
QUESTIONS
There will be 4 options.You have to select one option regarding the activity that is performed using designer?
Answer: Run the debugger, validate mappings and mapplets and import source definitions
QUESTIONS
What are the views available in the workflow monitor?
Answer: Task view, Gantt chart view
QUESTIONS
Which types of objects can read values from parameter files?
Answer: Mappings, Sessions and workflows.
QUESTIONS
Which set of privileges would be sufficient to use the workflow monitor with a specific folder?
Answer: Use the work flow monitor and execute permission on the folder
QUESTIONS
Where can the database connection properties be configured?
Answer: From the workflow manager menu or session properties tab.
QUESTIONS
A user must create copy of an object within another folder in the same repository. Select the statement that is true?
Answer: The folder in which the object is being copied should be open
QUESTIONS
What permissions are required to copy objects from one folder to another?
Answer: x
QUESTIONS
Which service you need to start first in informatica - Repository server, power center server or agent?
Answer: Start the Repository server
QUESTIONS
What is the purpose of output window?
Answer: x
QUESTIONS
Select the statement that is false?
Answer: The repository agent helps us to configure and start the repository server
QUESTIONS
Read carefully the Repository Manager part.
You need to select one option regarding the activity that is performed by Repository Manager.
Answer: Delete workflows and tasks, start workflow, configure connections
QUESTIONS
If primary index is present in oracle then does the bulk option work? - true/false
Answer: x
QUESTIONS
The power center server loads nulls into oracle. Which of the following are true
Answer: None of the above
QUESTIONS
Read the timer task part carefully from manual. You will get one question.
Answer: x
QUESTIONS
With power centre 7 which set of objects can be scheduled?
Answer: x
QUESTIONS
When the Use connection variable option is selected in the relational browser, where is the database connection specified
Answer: x
QUESTIONS
If repository tables are deleted then can you recover those?
Answer: x
QUESTIONS
A user is installing power centre 7 client software in a new client machine? Does he need a database userid and password?
Answer: NO
QUESTIONS
Which console is required prior to upgrading a repository to version 7
Answer: A repository server administration console and running repository server.
QUESTIONS
IS a repository server required to uses power centre?
Answer: x
QUESTIONS
A work flow is defined as
Answer: A set of instructions that tell the Informatica server how execute a set of tasks
QUESTIONS
Remember all the components that are visible in repository manager
Answer: Business components, mappings reusable transformations.
QUESTIONS
The power centre server fails to connect to the oracle database for the following reason.- you have to choose one answer.
Answer: x
QUESTIONS
You will be shown an error message related to a database and you have to specify the database the message is related to? Probably the
answer will be oracle
Answer: x
QUESTIONS
What is the purpose of lik condition?
Answer: prevent certain tasks from being executed.
QUESTIONS
How can you change the date/time display format of workflow manager ?
Answer: x
QUESTIONS
What privileges and permissions will be required to create a new connection object?
Answer: x
QUESTIONS
What is the meaning of the term execute permission on a folder?
Answer: Allows the user to execute or reschedule a workflow within that folder.
QUESTIONS
what is disadvantage of using shortcuts instead of copies?
Answer: change in shortcuts may invalidate mappings.
QUESTIONS
Which Informatica servers are visible in the workflow monitor after the user has connected to the repository?
Answer: All servers registered with repository
QUESTIONS
A workflow manager can be used to?
Answer: Create workflows that contains existing session tasks
QUESTIONS
Which types of objects are visible in the workflow monitor task view?
Answer: Workflows, Tasks and worker servers.
No comments:
Post a Comment