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 15107

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

Deloitte,

4 24749

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 7426

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?

2128

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

1 5972

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

1 4461

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 7423

how can i invoke pmcmd in command line prompt

1 4607

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 5820

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 10332

without update strategy how to insert &update?

DELL,

1 6590

what are the deliverables?in your project?

DELL,

2091

can u any challenge your project?

HP,

1977

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are connected or unconnected transformations?

1056

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2477

How to create Target definition for flat files?

1167

How to implement security measures using repository manager?

1092

What is a repository manager?

1039

Explain the code page compatibility?

1026

Explain the types of lookup transformation?

984

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1036

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1639

How to do the error handling of if ur source is flatfiles?

1923

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1933

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1939

is it possible to index the data in cache of lkp transformation ?

1969

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1983

Explain scd type 3 through mapping.

926

For More Un-Answered { Informatica } Questions Click Here