Informatica Interview Questions
Questions Answers Views Company eMail

Can we have a Mapping without a Source Qualifier?

Deloitte,

14 45474

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

Deloitte,

2 11857

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

TCS,

2 12402

how can we use sorter transformation in joins?

IBM,

5 15962

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

1834

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

2 8906

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 6630

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 25002

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 5386

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 7056

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

Accenture,

2 10104

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 10448

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 4972

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 4913

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

IBM, Wipro,

4 12304


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the scenario which compels informatica server to reject files?

579


update strategy transformation in informatica

622


How can you generate reports in informatica?

557


waht type of interface is used for testing the data in informatica

1814


Explain the features of connected and unconnected lookup.

517






what is INFORMATICA TESTING process

1814


Enlist few areas or real-time situations where informatica is required.

570


How do you load unique records into one target table and duplicate records into a different target table?

679


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1561


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8471


Which transformation should we use to normalise the COBOL and relational sources?

719


What is informatica worklet?

574


Mention few power centre client applications with their basic purpose?

506


What is data transformation manager process?

601


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1292