1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
Informatica Interview Questions
Questions Answers Views Company eMail

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

Cap Gemini,

1 7828

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 7739

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

 4 23159

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 15569

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

 1 5147

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

 1 4786

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

iGate,

2 5669

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

iGate,

1 5514

how to sort date field in infomatica?

 2 6004

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

 1 4150

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 4034

HOW TO DELETE A RECORD FROM FLAT FILE

TCS,

6 13524

What are the challenges you have faced in your project?

Cognizant, Infosys,

1 16939

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

TCS,

2 8688

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

TCS,

1710

Post New Informatica Questions

Un-Answered Questions { Informatica }

server hot-ws270 is connect to Repository B. What does it mean?

1843

What is sequence generator transformation in informatica?

610

Why do we need informatica?

546

Please let me know how to make Data masking in informatica..

1255

What are the new features of Power Center 5.0?

1221




What is dimensional table? Explain the different dimensions.

640

explain abt ur project architecture?

1749

What is meant by lookup transformation? Explain the types of lookup transformation?

555

Scheduling properties,whats the default (sequential)

1452

Differentiate between joiner and lookup transformation?

603

I have a flat file, want to reverse the contents of the flat file

680

Difference between Data and Index Caches?

643

What can we do to improve the performance of informatica aggregator transformation?

607

According to his methodology what all you need before you build a datawarehouse

1179

Why is sorter an active transformation?

653

For More Un-Answered { Informatica } Questions Click Here