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

Informatica Interview Questions

Questions Answers Views Company eMail

Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 6668

hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

IBM,

9 10796

While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 9074

Can we update the data in flat file using update strategy?

3 16766

there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

TCS,

2 6723

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

IBM,

1 5125

can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?

Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,

1 17793

how to connect two or more table with single source qualifier?

IBM,

4 20962

Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve

TCS,

15 26093

how to import multiple flat files in to single target where there is no common column in the flat files

TCS,

2 7330

In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 9605

what is confirmed fact?

2 18636

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 6302

what is difference between mapping and mapplet ?

TCS,

2 18001

What is confirmed fact in dataware housing?

Hewitt, TCS,

2 6977

Post New Informatica Questions

Un-Answered Questions { Informatica }

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1082

Explain the difference between a data warehouse and a data mart?

1062

How can we use batches?

1030

What are the different clients of powercenter?

1065

State the differences between sql override and lookup override?

1215

How might you approve all mappings in the archive all the while?

1020

In development project what is the process to follow for an etl developer from day1

1724

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

2115

What differs when we choose the sorted input for aggregator transformation?

1031

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2140

Explain what are the different versions of informatica?

1101

Define joiner transformation?

1056

What is meant by incremental aggregation?

1111

Briefly explain the aggregator transformation?

1015

Can we create a node as a gateway node and the same node can be assigned to a grid?

1085

For More Un-Answered { Informatica } Questions Click Here