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

Informatica Interview Questions

Questions Answers Views Company eMail

How informatica recognizes mapping?

CTS,

2 7384

Is snow flake or star schema used? If star schema means why?

CTS, Sonata,

4 9485

I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

DELL,

2 8653

how to read data from website into informatica? plsss send answers ASAP thanks in advance.

DELL,

1 8165

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 4182

how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

CTS,

3 14324

get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

Infosys,

2278

get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

Infosys,

3 9794

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

Accenture,

2 18109

what is index?how it can work in informatica

2040

how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?

DELL,

5 11467

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

IBM,

5 9864

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

IBM,

2 6733

What is log file,and where is it located,why u r using the log file

TCS,

1 8204

what type of transformation is not supported by mapplets?

CTS,

4 15624

Post New Informatica Questions

Un-Answered Questions { Informatica }

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2075

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1100

1932

what is size of u r database?

2306

explain abt ur project architecture?

2193

Write the prerequisite tasks to achieve the session partition?

1158

Explain how to import oracle sequence into informatica?

1011

How can you increase the performance in joiner transformation?

1190

What are the different types of transformation available in informatica.

1105

What do you mean by worklet?

1064

What is target load order?

1246

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2280

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1058

How is union transformation utilized?

1009

What is complex mapping?

1120

For More Un-Answered { Informatica } Questions Click Here