Informatica Interview Questions
Questions Answers Views Company eMail

how we can add header and footer to flat files?

Tech Mahindra, Zensar,

2 13921

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

Deloitte,

4 23209

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 5806

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

BTBP,

3 6319

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?

1582

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

1 5293

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

1 3689

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 6330

how can i invoke pmcmd in command line prompt

1 3922

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

1506

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

L&T,

1 5119

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 8332

without update strategy how to insert &update?

DELL,

1 5760

what are the deliverables?in your project?

DELL,

1624

can u any challenge your project?

HP,

1581


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is joiner transformation?

562


what is informatica metadata?

574


How can we handle two sessions in informatica?

596


What is lookup change?

598


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1625






can anyone suggest best free Talend data integration training online

1232


permutations of mapplet

2013


What is workflow? What are the components of workflow manager?

682


Can we change Dynamic to Static or Persistent cache? If so what happens?

1694


What is the difference between STOP and ABORT options in Workflow Monitor?

671


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

1550


define galaxy repository in informatica

1702


Explain sql transformation in script mode examples in informatica

575


What is complex mapping?

615


When do you use sql override in a lookup transformation?

560