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,

2991

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 15010

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 8084

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

CSC,

7 12547

Are there any types of Dynamic Caches in informatica

Accenture,

4 8852

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 8630

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 11334

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 9104

what is INFORMATICA TESTING process

2294

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 4750

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

2271

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

TCS,

4 23671

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

TCS,

2 7454

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 4973

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

HCL, TCS,

2 14009

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is informatica?

1155

How to use pmcmd utility command?

1032

What is the use of code page?

1096

What are active transformations.

1656

What does reusable transformation mean?

1132

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2057

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5793

Under what condition selecting sorted input in aggregator may fail the session?

1127

Where can we find the throughput option in informatica?

1063

What is the fact table?

1071

Differentiate between source qualifier and filter transformation?

1578

What is informatica metadata and where is it stored?

991

What is a standalone command task?

1204

What are the main features of Oracle 8i with context to datawarehouse?

2112

Tell me about MD5 functions in informatica

929

For More Un-Answered { Informatica } Questions Click Here