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 6654

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 10775

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

4 9061

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

3 16750

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 6709

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 5122

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 17773

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

IBM,

4 20940

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 26050

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

TCS,

2 7316

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

1 9596

what is confirmed fact?

2 18624

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 6293

what is difference between mapping and mapplet ?

TCS,

2 17980

What is confirmed fact in dataware housing?

Hewitt, TCS,

2 6967

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain your project of banking domian.

1652

What are the types of lookup transformation?

1077

How will the document be delivered to me?

1085

How to configure mapping in informatica?

1173

-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?

5790

What is olap (on-line analytical processing?

1069

What is the surrogate key?

1261

What is the difference between STOP and ABORT options in Workflow Monitor?

1257

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

2119

Explian the Process of deployment groups in informatica

1062

What is the sequence generator transformation in informatica?

1182

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

1018

Can we get 1st record through Informatica(without sequence number).

1479

Explain joiner transformation in informatica

1124

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

2499

For More Un-Answered { Informatica } Questions Click Here