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 8392

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

Patni,

3 10035

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

TCS,

2 5155

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

TCS,

2 7214

How informatica process data means how informatica works?

TCS,

2 13292

Can we run session without using workflows?

TCS,

5 22494

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 7921

what is the location of parameter file in informatica?

TCS,

1 8546

what is runtime variable?

TCS,

3 7560

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

TCS,

6 12275

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

TCS,

2910

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

TetraSoft,

6 15044

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

KPIT,

1 9828

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 8043

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

Cognizant, Flextronics,

2193

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the reusable transformations?

1221

Explain lookup transformation in informatica

1131

What is the difference between STOP and ABORT options in Workflow Monitor?

1318

Explain how many types of dimensions are available in informatica?

1175

What is the fact table?

1141

Explain in detail scd type 2 through mapping.

1092

What are the various types of transformation?

1246

What is a repository manager?

1148

How does the aggregator transformation handle null values?

1197

How to convert multiple rows to single row (multiple columns) in informatica

1429

What are the different ways to implement parallel processing in informatica?

1490

Name the different lookup cache(s)?

1294

What is the sql query overwrite in source qualifier in informatica

1142

What are batches?

1190

What is informatica?

1220

For More Un-Answered { Informatica } Questions Click Here