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 24910

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 7563

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?

2180

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 4560

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 7539

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 10570

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 }

can u give example for factless fact table

6647

What are the features of complex mapping?

1157

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2339

What are multi-group transformations?

1095

What is a dimensional model?

978

How we can create indexes after completing the loan process?

1211

How does a sorter cache works?

1069

What all are steps in up gradation of Informatica server?

1045

Whats there in global repository

1692

How to elaborate tracing level?

1178

What is rank transform?

996

Is there any way to read the ms excel datas directly into informatica?

1022

wat are deployement groups in informatica, how it will be used for developers

1719

What are the different options available for update strategy?

1003

What do mean by local and global repository?

1226

For More Un-Answered { Informatica } Questions Click Here