Informatica Interview Questions
Questions Answers Views Company eMail

what happens when a batch fails?

3 7204

connected and unconnected lookups?

4 7237

what is scd?

6 15923

what are surrogate keys?

5 10079

how do u tune queries?

1 5729

what is metadata?

6 8175

Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 10718

what is the difference between onsite & client site?

1 9545

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

Infosys, TCS,

2 16862

how the server recognises , if the session fails after loading the 100 records in to the target

TCS,

2 8722

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

Altisource, TCS,

14 20309

if the session fails after 100 records agian we have to starts the session or we go for recovery session

TCS,

2 9325

How do you take care of security using a repository manager

2 7005

Can you use one mapping to populate two tables in different schemas

2 8516

What are differences between Informatica 7.1 and 6.1

3 9722


Post New Informatica Questions

Un-Answered Questions { Informatica }

Partition, what happens if the specified key range is shorter and longer

2024


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

589


How can you validate all mappings in the repository simultaneously?

745


What are the main features of Oracle 8i with context to datawarehouse?

1668


What is a stored procedure transformation?

603






What are mapplets?

805


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1621


Write the program through which the records can be updated?

501


What are the different ways to implement parallel processing in informatica?

851


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

715


How to elaborate tracing level?

676


What is native users?

711


How to do the error handling of if ur source is flatfiles?

1495


Mention some types of transformation?

597


Is stop and abort are same in informatica?

560