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 6766

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 11056

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

4 9200

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

3 16881

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 6813

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 5204

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 17872

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

IBM,

4 21082

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 26626

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

TCS,

2 7425

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

1 9676

what is confirmed fact?

2 18734

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 6409

what is difference between mapping and mapplet ?

TCS,

2 18162

What is confirmed fact in dataware housing?

Hewitt, TCS,

2 7112

Post New Informatica Questions

Un-Answered Questions { Informatica }

Briefly explain the aggregator transformation?

1068

can anyone explain me about retail domain project in informatica?

8005

Explian the Process of deployment groups in informatica

1102

How identifying bottlenecks in various components of informatica and resolving them?

1182

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2358

 Informatica Checkpoints

3380

What is union transformation in informatica?

1194

Can we create multiple integration service on single repository?

1243

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2088

Explain the mapping variable usage example in informatica

1228

Explain lookup transformation is active in informatica

1152

What is dimensional table? Explain the different dimensions.

1258

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

2007

Mention a few design and development best practices for informatica?

1047

What is the function of union transformation?

1207

For More Un-Answered { Informatica } Questions Click Here