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

2153

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

IBM,

2 9906

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,

2412

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

IBM, TCS,

2 11098

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 10140

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 9007

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

Flextronics,

5 11533

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

TCS,

2 8405

How mapping parameter and variable works

1 4345

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 6793

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 9597

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

iNautix,

7 21990

what type of problem you faced insales project or insurance project

Sony,

1 5291

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 6153

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 9748

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain direct and indirect flat file loading (source file type) - informatica

1359

What is a dimensional model?

1035

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

2193

design of staging area?

2080

What is the status code in stored procedure transformation?

1236

What is union transformation in informatica?

1194

Different sorts of metadata that stores in the storage facility?

1076

How to generate sequence numbers?

1138

During the running session, output files are created by informatica server. Enlist few of them.

1027

How to create the source and target database connections in server manager?

1132

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

1324

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4785

Enlist the differences between database and data warehouse.

1167

Describe data concatenation?

1127

What is the need for an etl tool?

1105

For More Un-Answered { Informatica } Questions Click Here