Informatica Interview Questions
Questions Answers Views Company eMail

in realtime which situations u can use unconnected lookup transformation

Patni,

2 7160

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

Patni,

3 8520

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

TCS,

2 4141

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

TCS,

2 5813

How informatica process data means how informatica works?

TCS,

2 12078

Can we run session without using workflows?

TCS,

5 20084

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 6783

what is the location of parameter file in informatica?

TCS,

1 7623

what is runtime variable?

TCS,

3 6120

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

TCS,

6 10102

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

TCS,

2378

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

TetraSoft,

6 12711

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

KPIT,

1 9016

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 6687

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

Cognizant, Flextronics,

1740


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is meant by pre and post session shell command?

610


Design a mapping to load the cumulative sum of salaries of employees into target table?

884


What are some examples of informatica etl programs?

523


What is union transformation in informatica?

687


What is data movement mode in Informatica and difference between them?

611






How do you manage the Parameter files while migrating your data from one environment to another environment?

532


In informatica workflow manager, how many repositories can be created?

769


differences between service based and product based?

1555


How to differentiate between the active and passive transformations?

615


What are the different lookup cache(s)?

610


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7749


How to elaborate powercenter integration service?

639


What are the performance considerations when working with aggregator transformation?

667


How do we call shell scripts from informatica?

583


Write the unconnected lookup syntax?

644