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 8262

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

Patni,

3 9885

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

TCS,

2 5027

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

TCS,

2 7093

How informatica process data means how informatica works?

TCS,

2 13155

Can we run session without using workflows?

TCS,

5 22285

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 7816

what is the location of parameter file in informatica?

TCS,

1 8457

what is runtime variable?

TCS,

3 7386

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

TCS,

6 12043

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

TCS,

2851

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

TetraSoft,

6 14773

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

KPIT,

1 9734

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 7855

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

Cognizant, Flextronics,

2142

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the difference between writing a joiner query in ANSI style and THETA style?

2374

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1244

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

1956

How can you increase the performance in joiner transformation?

1183

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1197

Can we change Dynamic to Static or Persistent cache? If so what happens?

2203

define galaxy repository in informatica

2220

How many types of sessions are there in informatica.please explain them?

1161

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1079

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5669

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1273

How do you promote a non-reusable transformation to reusable transformation?

1132

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2031

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2316

Can you generate sequence numbers without using the sequence generator transformation?

1117

For More Un-Answered { Informatica } Questions Click Here