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,

2929

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 14760

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 7937

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

CSC,

7 12268

Are there any types of Dynamic Caches in informatica

Accenture,

4 8667

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 8452

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 11123

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 9005

what is INFORMATICA TESTING process

2250

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 4678

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

2218

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

TCS,

4 23495

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

TCS,

2 7352

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 4895

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

HCL, TCS,

2 13858

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the transformations that are not supported in mapplet?

975

What is informatica?

1090

Describe expression transformation?

1067

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5593

Define pmcmd command?

1002

what are the Methods For Creating Reusable Transformations?

1117

Partition, what happens if the specified key range is shorter and longer

2449

what is size of u r database?

2266

What is workflow? What are the components of workflow manager?

1133

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1956

What is a joiner transformation?

948

What is sq transformation?

1097

What happens when a session fails and you click on recover?

1088

What is mapplet in informatica?

997

What are the differences between source qualifier and joiner transformation?

1010

For More Un-Answered { Informatica } Questions Click Here