adspace


Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

7 17053

what is the architecture of any Data warehousing project?

IBM,

5 21312

what is the flow?

1 8650

How to load time dimension?

Ford,

1 15943

In update strategy target table or flat file which gives more performance ? why?

7 26833

How do you create single lookup transformation using multiple tables?

TCS,

6 45134

Why touse stored procedure in ETL Application?

2 12182

How to improve the performance of Aggregate transformation?

Dmss,

3 14633

What is critical mapping?

2 11589

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

Accenture,

1 20102

How to view and Generate Metadata Reports?

1 8025

what is difference between COM & DCOM?

Satyam,

1 11389

what is the gap analysis?

1 9662

How to recover sessions in concurrent batches?

3 16048

what are the different types of transformation available in informatica and what are the mostly used ?

TCS,

3 25616


Post New Informatica Questions

Un-Answered Questions { Informatica }

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2448


How to create the source and target database connections in server manager?

1177


EXL informatica Questions

1485


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

4290


Write the unconnected lookup syntax?

1179


draw informatica architecture 8.6 ?

3972


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1279


What is dimensional table?

1201


Explain in detail about scd type 1 through mapping.

1683


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4827


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1228


Write the unconnected lookup syntax and how to return more than one column.

1194


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8327


How do you remove duplicate records in informatica? And how many ways are there to do it?

1268


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2856