1.
When u r checking out what ll happens for version no?
a. Increase
b. decrease
c.reset to 0
d. reset to 1
e. no change

2.
Salary of all employees needed to add with the commision.
What transfrmation to be used?

a. SQ and Expression
b. SQ
c. Update Strategy
d. Expression

3.
Which of the task is used to run a session based on success
of the other session?
a. Decision
b. Event wait
c. Email
d. Command
e. None

4.
Types of sources in Informatica?
a. Homogenous n Heterogenous
b. None
c. Cobol n XML
d. Flat files
e. Flat files and Homogenous n Heterogenous

5.
Servers are available in informatica?
a. Informatica Server and Workflow server
b. Informatica Server and Informatica Repository Server
c. Informatica Server
d. Workflow server
e. Informatica Repository Server

6.
While using Pmcmd in cmd line mode, each command must
include the connection info of which of the following?
a. workflow manager
b. Power Center server
c. Workflow monitor
d. Repository manager
e. Designer

7.
Workflow montior displays workflows that have run
a. once
b. twice
c. never
d.four times
e. thrice

8. Mode for handling sessions n workflows?
a. server mode
b. Wait mode
c. Command line mode
d. User mode
e. Interactive mode


9. Connection details configured in?
a. Mapping designer
b. Workflow manager
c. Workflow monitor
d. Repository manager
e. Worklet designer

Thanks in Advance


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

After we make a folder shared can it be reversed?Why?

2 Answers   Accenture,


What is the difference b/w natural key and surrogate key

1 Answers  


How to recover sessions in concurrent batches?

1 Answers  


one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,


in static and dynamic which one is better

2 Answers  






What are active transformations.

0 Answers  


What are the settings that you use to configure the joiner transformation?

0 Answers   Informatica,


Define Pmrep command?

0 Answers  


What is the default join that source qualifier provides?

3 Answers   Informatica,


Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

0 Answers  


What is junk dimention?

3 Answers   Patni,


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

2 Answers   Zensar,


Categories