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 10035

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 8297

How mapping parameter and variable works

1 4253

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 9547

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1109

What are the popular informatica products?

1012

tell me about your project functionality

2341

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

1110

What is domain in terms of informatica?

1007

Where can we find the throughput option in informatica?

1063

What are connected or unconnected transformations?

1123

What is rank transformation?

991

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1081

explain about unit testing? in real time?

2205

What if the source is a flat-file?

1111

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2554

where to store informatica rejected data?

1093

What is the need for an etl tool?

1068

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

2395

For More Un-Answered { Informatica } Questions Click Here