Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

6 7794

what is the architecture of any Data warehousing project?


4 11831

what is the flow?

1 4011

How to load time dimension?


1 10191

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

7 15500

How do you create single lookup transformation using multiple tables?


6 26874

Why touse stored procedure in ETL Application?

2 6911

How to improve the performance of Aggregate transformation?


3 8231

What is critical mapping?

2 6408

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


1 13289

How to view and Generate Metadata Reports?

1 4203

what is difference between COM & DCOM?


1 7738

what is the gap analysis?

1 5871

How to recover sessions in concurrent batches?

3 10089

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


3 18039

Post New Informatica Questions

Un-Answered Questions { Informatica }

Why do you use Mapping Parameter and mapping variable?


What are the issues you have faced in your project? How did you overcome those issues?


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N


What is the meaning of up gradation of repository?


if we have a delimiters at unwanted places in a flat file how can we over come those.


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


Scheduling properties,whats the default (sequential)


scenario where i can use only concurrent execution of workflow.


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.


how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.


explan ur project architecture?


Differentiate between Load Manager and DTM?


tell me 5 session failure in real time how can you solve that in your project?


what is the difference between informatica6.1 and infomatica7.1