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 6560

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 10555

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

4 8926

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

3 16609

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 6610

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 5041

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 17663

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

IBM,

4 20799

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 25633

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

TCS,

2 7209

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

1 9524

what is confirmed fact?

2 18509

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 6209

what is difference between mapping and mapplet ?

TCS,

2 17844

What is confirmed fact in dataware housing?

Hewitt, TCS,

2 6849

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the types of caches in lookup?

993

explain about unit testing? in real time?

2156

What is the sql query overwrite in source qualifier in informatica

1044

What is the use of transformation?

963

Under what condition selecting sorted input in aggregator may fail the session?

1080

How to start a workflow using pmcmd command?

1199

How do you remove duplicate records in informatica? And how many ways are there to do it?

1132

I have a flat file, want to reverse the contents of the flat file

1078

How many transformations can be used in mapplets.

1890

what is diff b/t sorter t/r and agg have the option sorter property...

2143

server hot-ws270 is connect to Repository B. What does it mean?

2473

What is informatica? Why do we need it?

1058

Describe the impact of several join conditions and join order in a joiner transformation?

1023

Explain sessions?

998

How does the aggregator transformation handle null values?

1106

For More Un-Answered { Informatica } Questions Click Here