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,

2990

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 15005

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 8078

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

CSC,

7 12537

Are there any types of Dynamic Caches in informatica

Accenture,

4 8847

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 8625

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 11332

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 9103

what is INFORMATICA TESTING process

2289

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 4746

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 23665

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

TCS,

2 7449

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 14004

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is incremental aggregation?

1083

Does an informatica transformation support only aggregate expressions?

1042

What is a stored procedure transformation?

1053

what is song in infrmatica...?

2236

What is the status code in stored procedure transformation?

1182

What are session parameters ? How do you set them?

1849

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2008

What is a filter transformation?

1043

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2420

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2119

What is an expression transformation?

1014

How can we use mapping variables in informatica? Where do we use them?

1200

How to create the source and target database connections in server manager?

1090

What is repository manager?

987

Explain Dataware house architecture .how data flow from intial to end?

2582

For More Un-Answered { Informatica } Questions Click Here