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 23161

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 5149

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

 1 4788

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

iGate,

2 5673

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

iGate,

1 5515

how to sort date field in infomatica?

 2 6007

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

 1 4153

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 4035

HOW TO DELETE A RECORD FROM FLAT FILE

TCS,

6 13526

What are the challenges you have faced in your project?

Cognizant, Infosys,

1 16941

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

TCS,

2 8691

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

TCS,

1711

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are active and passive transformations?

639

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1578

What do you mean by blocking transformation?

574

Enlist the various types of transformations.

546

waht type of interface is used for testing the data in informatica

1825




In how many ways we can create ports?

694

What are the databases that informatica can connect to windows?

569

What is blocking transformation?

704

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

606

What are the prerequisite tasks to achieve the session partition?

699

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1685

What is primary and backup node?

686

What does refresh system mean, and what are its distinctive choice?

560

Why union transformation is an active transformation?

646

What is the difference between informatica 7.0 and 8.0?

558

For More Un-Answered { Informatica } Questions Click Here