Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2048

Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

IBM,

2 9649

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

IBM,

2324

What is best approach to load 100 different source files (Different structure) to differet target tables ?

IBM, TCS,

2 10857

How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

IBM,

2 9919

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

IBM, WalMart,

2 8804

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

Flextronics,

5 11156

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

TCS,

2 8193

How mapping parameter and variable works

1 4166

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

iNautix,

1 6649

In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

iNautix,

5 9218

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

iNautix,

7 21540

what type of problem you faced insales project or insurance project

Sony,

1 5130

please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

Accenture,

1 5991

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 9358

Post New Informatica Questions

Un-Answered Questions { Informatica }

Is it possible to define a single node as a Gateway node as well as worker node?

1075

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2118

What is a filter transformation and why it is an active one?

921

How can informatica be used for an organization?

1147

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1819

Make a note of the quantity vaults made in informatica?

953

What is meant by LDAP users?

1133

What are the different options available for update strategy?

959

Enlist some properties of sessions.

1034

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2339

How can repository reports be accessed without sql or other transformations?

1175

What is joiner transformation?

965

What are the types of caches in lookup? Explain them.

931

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2268

What are the advantages of using informatica as an etl tool over teradata?

989

For More Un-Answered { Informatica } Questions Click Here