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 15423

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

Deloitte,

4 25095

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 7115

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

BTBP,

3 7681

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?

2255

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

1 6118

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

1 4648

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 7651

how can i invoke pmcmd in command line prompt

1 4764

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

2049

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

L&T,

1 6011

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 10836

without update strategy how to insert &update?

DELL,

1 6788

what are the deliverables?in your project?

DELL,

2198

can u any challenge your project?

HP,

2085

Post New Informatica Questions

Un-Answered Questions { Informatica }

How can we use batches?

1066

What is the commit type if you have a transaction control transformation in the mapping?

1100

What is enterprise data warehousing?

1108

r u done any partitions in ur project?

1871

Mention few power centre client applications with their basic purpose?

1002

What are mapplets? How is it different from a Reusable Transformation?

1139

How you prepared reports for OLAP?

1662

What is workflow monitor?

1103

Where is metadata stored?

1197

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1156

Global and Local shortcuts. Advantages.

2093

Explain why we use partitioning the session in informatica?

1168

update strategy transformation in informatica

1126

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7372

What is deployment group?

1304

For More Un-Answered { Informatica } Questions Click Here