Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

What is Java Transformation? what are the uses of it?

TCS,

3066

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

TCS,

7 15275

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

Polaris,

4 8261

If a table contains 100 records we have to fetch 50-100 records from source to target?how

CSC,

7 12774

Are there any types of Dynamic Caches in informatica

Accenture,

4 9015

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

Polaris,

4 8813

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

Accenture,

6 11555

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 9249

what is INFORMATICA TESTING process

2335

PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 4857

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

2321

Can we update a target table (without primarykey) by using update strategy transformation?

TCS,

4 23862

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

TCS,

2 7598

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

TCS,

1 5062

Which one is better performance wise connected/un-connected lkp?why?

HCL, TCS,

2 14174

Post New Informatica Questions

Un-Answered Questions { Informatica }

Where are the source flat files kept before running the session?

1144

How to load last n records of file into target table - informatica

1137

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2799

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1158

Explain the different lookup methods used in informatica?

1098

lookup transformation with screenshots

4052

What are the tasks that source qualifier perform?

1145

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2418

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1214

How you prepared reports for OLAP?

1662

What are the different versions of informatica?

1338

What is complex mapping?

1173

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2305

What is the command used to run a batch?

1115

COM components can be used in Informatica

2457

For More Un-Answered { Informatica } Questions Click Here