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 8169

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

Patni,

3 9745

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

TCS,

2 4954

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

TCS,

2 6974

How informatica process data means how informatica works?

TCS,

2 13059

Can we run session without using workflows?

TCS,

5 22092

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 7735

what is the location of parameter file in informatica?

TCS,

1 8397

what is runtime variable?

TCS,

3 7266

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

TCS,

6 11859

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

TCS,

2815

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

TetraSoft,

6 14554

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

KPIT,

1 9657

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 7738

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

Cognizant, Flextronics,

2106

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain how to import oracle sequence into informatica?

968

hi real timers . iam waiting for ur reply regarding ETL TESTING

2218

State the differences between sql override and lookup override?

1133

How to load the data from a flat file into the target where the source flat file name changes daily?

1021

In how many ways we can create ports?

1081

Where is metadata stored?

1059

Where do we use mapping variables in informatica?

1012

What is the need of etl tools?

1071

What is xml source qualifier transformation in informatica?

1186

What is workflow manager?

1003

Informatica settings are available in which file?

949

What is pmcmd command?

1053

What is confirmed fact in dataware housing?

6848

How to do unit testing in informatica? How to load data in informatica ?

1060

what is the size of your data warehousing?

2058

For More Un-Answered { Informatica } Questions Click Here