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

2107

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

IBM,

2 9760

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,

2365

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

IBM, TCS,

2 10972

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 10034

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 8896

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

Flextronics,

5 11332

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

TCS,

2 8296

How mapping parameter and variable works

1 4252

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 6710

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 9398

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

iNautix,

7 21754

what type of problem you faced insales project or insurance project

Sony,

1 5194

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 6058

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 9546

Post New Informatica Questions

Un-Answered Questions { Informatica }

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1796

Explain about cumulative Sum or moving sum?

1043

What is main use of mapplet?

1132

Implementation methodology

1712

What are the different versions of informatica?

1275

What are the transformations that are not supported in mapplet?

1027

what is diff b/t sorter t/r and agg have the option sorter property...

2171

Define joiner transformation?

1049

What is the different lookup cache(s)?

1086

Under which circumstances, informatica server creates reject files?

1095

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2323

Explain lookup transformation source types in informatica

1098

What do you mean by enterprise data warehousing?

1065

Differentiate between Load Manager and DTM?

2153

Differences between version 7.x and 8.x.

1893

For More Un-Answered { Informatica } Questions Click Here