Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

How to eliminate duplicate records in informatica mapping? Explain with an example....

Cap Gemini,

1 8598

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

Cap Gemini,

3 8893

Using Expression transformation how to remove duplicate records from a relational source?

4 24871

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

Cap Gemini,

1 16523

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 5884

plz plz plz send client names and project names in informatica?

1 5759

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

iGate,

2 6837

how we can do session partition in informatica any one explain me clearly? thanks advance.

iGate,

1 6284

how to sort date field in infomatica?

2 6876

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 4924

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 4958

HOW TO DELETE A RECORD FROM FLAT FILE

TCS,

6 15747

What are the challenges you have faced in your project?

Cognizant, Infosys,

1 17883

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

TCS,

2 9693

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

TCS,

2214

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is a code page?

1182

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7462

How to extract sap data using informatica? What is abap? What are idocs?

1185

Can we create two repositories on same database instance in oracle?

1103

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1588

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1089

What is union transformation?

970

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2461

What are the mapping parameters and mapping variables?

1210

Please let me know how to make encryption and decryption with example?

1908

What's the layout of parameter file (what does a parameter file contain?)?

2389

What is the status code in stored procedure transformation?

1185

Reusable transformation and shortcut differences

1844

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7188

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1130

For More Un-Answered { Informatica } Questions Click Here