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 8274

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

Patni,

3 9898

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

TCS,

2 5033

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

TCS,

2 7105

How informatica process data means how informatica works?

TCS,

2 13160

Can we run session without using workflows?

TCS,

5 22300

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 7825

what is the location of parameter file in informatica?

TCS,

1 8462

what is runtime variable?

TCS,

3 7392

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

TCS,

6 12069

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

TCS,

2861

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

TetraSoft,

6 14787

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

KPIT,

1 9745

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 7871

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

Cognizant, Flextronics,

2146

Post New Informatica Questions

Un-Answered Questions { Informatica }

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2304

What is an Integration service in Informatica?

1134

What is InformaticaPowerCenter?

1136

As union transformation gives UNION ALL output, how you will get the UNION output?

1108

Where can we find the throughput option in informatica?

1063

In which transformation you cannot drag ports into it?

1320

What is meant by lookup transformation?

1110

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2395

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

2075

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

2256

Explain how to import oracle sequence into informatica?

1011

What do you mean incremental aggregation?

1076

How to start a workflow using pmcmd command?

1250

How to elaborate tracing level?

1179

What is the function of union transformation?

1134

For More Un-Answered { Informatica } Questions Click Here