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

Informatica Interview Questions

Questions Answers Views Company eMail

Can we have a Mapping without a Source Qualifier?

Deloitte,

14 49320

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

Deloitte,

2 13047

what is the use of Java Transformation in Informatica 8.x?

TCS,

2 13559

how can we use sorter transformation in joins?

IBM,

5 17758

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2281

any body can say about all versions of informatica ?how many versions ?

2 9855

I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2, Please let me know how can we acheive this in informatica Thanks in advance

4 7882

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000

Deloitte,

7 27065

I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?

3 6374

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?

6 8637

How to convert flat file into xml file? How to tune joiner?

Accenture,

2 11046

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

Accenture,

7 12498

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

CTS,

2 5829

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 5979

What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

IBM, Wipro,

4 13489

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the need of etl tools?

1053

what is INFORMATICA TESTING process

2228

Explain in detail scd type 2 through mapping.

991

What is aggregator transformation in informatica?

900

How will the document be delivered to me?

1021

What are the different versions of informatica?

1188

Explain lookup transformation in informatica

1007

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1730

What is informatica?

1080

What is the meaning of decode in informatica?

1076

Can you use flat files in Mapplets.

2612

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?

1026

What is sq transformation?

1082

Why update strategy and union transformations are active? Explain with examples.

1176

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6915

For More Un-Answered { Informatica } Questions Click Here