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

Informatica Interview Questions

Questions Answers Views Company eMail

how we can add header and footer to flat files?

Tech Mahindra, Zensar,

2 15113

how can you load data into target table without leading zeor's

Deloitte,

4 24755

My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000

TCS,

3 6842

can you please explain me pre session and post session options?

BTBP,

3 7436

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2131

How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica

1 5973

How can we integrate different flat file data in a single mapping and with in a single execution

1 4463

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

TCS,

2 7425

how can i invoke pmcmd in command line prompt

1 4610

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1943

i have 2 session s1 execute s2 load first session fail what is the reason?

L&T,

1 5825

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

Polaris,

7 10343

without update strategy how to insert &update?

DELL,

1 6593

what are the deliverables?in your project?

DELL,

2092

can u any challenge your project?

HP,

1977

Post New Informatica Questions

Un-Answered Questions { Informatica }

How you can differentiate between connected lookup and unconnected lookup?

1016

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1206

What are the issues you have faced in your project? How did you overcome those issues?

2299

What can we do to improve the performance of informatica aggregator transformation?

1050

What does “tail –f” command do and what is its use as an Informatica admin.

1041

What is the meaning of decode in informatica?

1083

What are the steps involved in the migration from older version to newer version of Informatica Server?

2055

Enlist the differences between database and data warehouse.

1050

What do you mean by filter transformation?

911

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1052

How to elaborate powercenter integration service?

1084

What are the different types of transformation available in informatica.

1040

What is status code in informatica?

968

How do you load only null records into target? Explain through mapping flow.

1969

How can we use mapping variables in informatica?

1012

For More Un-Answered { Informatica } Questions Click Here