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

Informatica Interview Questions

Questions Answers Views Company eMail

in realtime which situations u can use unconnected lookup transformation

Patni,

2 8283

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

Patni,

3 9913

i have source in oracle 10g,oracle 8i how will u take the data from two sources

TCS,

2 5040

why we are using surogate key in real time give me explanation

TCS,

2 7108

How informatica process data means how informatica works?

TCS,

2 13172

Can we run session without using workflows?

TCS,

5 22318

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

HCL, HP,

2 7828

what is the location of parameter file in informatica?

TCS,

1 8466

what is runtime variable?

TCS,

3 7410

which is better perfomancewise lookup or joiner and why?can anyone give example?

TCS,

6 12082

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

TCS,

2870

How to delete first 3 rows & last 3 rows in target table in informatica

TetraSoft,

6 14801

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

KPIT,

1 9754

write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

Cognizant, Flextronics,

3 7877

what is the size ur source like(file system or database)? how many record daily come u r banking project?

Cognizant, Flextronics,

2148

Post New Informatica Questions

Un-Answered Questions { Informatica }

Parameter and variable differences

2063

How to extract sap data using informatica? What is abap? What are idocs?

1185

What is a rank transform?

1092

Why is sorter an active transformation?

1134

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1712

What is exclusive and normal mode for repository services?

1149

What is domain in terms of informatica?

1009

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

1132

What is meant by query override?

1061

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

2128

Define joiner transformation?

1056

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2078

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1965

How do you load only null records into target?

1220

Briefly describe lookup transformation?

1046

For More Un-Answered { Informatica } Questions Click Here