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 8135

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

Patni,

3 9697

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

TCS,

2 4924

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

TCS,

2 6940

How informatica process data means how informatica works?

TCS,

2 13017

Can we run session without using workflows?

TCS,

5 22024

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 7696

what is the location of parameter file in informatica?

TCS,

1 8376

what is runtime variable?

TCS,

3 7227

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

TCS,

6 11793

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

TCS,

2800

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

TetraSoft,

6 14498

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

KPIT,

1 9636

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 7706

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

Cognizant, Flextronics,

2096

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is dimensional table?

1004

What are the settings that you use to configure the joiner transformation?

1003

Please let me know how to make Data masking in informatica..

1665

Briefly define a session task?

1057

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1807

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

1319

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2058

What is the difference between informatica 7.0 and 8.0?

954

How identifying bottlenecks in various components of informatica and resolving them?

1057

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2077

how we can load rejected record's at run time?(not through bad files)

2315

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1999

How do you migrate data from one environment to another?

1044

What is the benefit of partitioning a session?

1105

Do you find any difficulty while working with flat files as source and target?

1054

For More Un-Answered { Informatica } Questions Click Here