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 15276

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

Deloitte,

4 24912

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 6957

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

BTBP,

3 7564

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?

2182

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

1 6038

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

1 4563

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 7540

how can i invoke pmcmd in command line prompt

1 4697

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

2003

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

L&T,

1 5916

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 10573

without update strategy how to insert &update?

DELL,

1 6693

what are the deliverables?in your project?

DELL,

2152

can u any challenge your project?

HP,

2033

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the new features of Power Center 5.0?

1779

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

1127

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2066

What are different types of transformations available in informatica?

992

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2058

How will the document be delivered to me?

1085

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

2174

What is main use of mapplet?

1132

What are the types of data warehouses?

1526

What are the types of lookup transformation?

1081

generate date / time dimension in informatica

1125

In warehouses how many schemas are there?

1073

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

1056

What are the features of complex mapping?

1159

How can a transformation be made reusable?

1168

For More Un-Answered { Informatica } Questions Click Here