Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

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

Cap Gemini,

1 6911

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 6145

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

4 20723

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 13734

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

1 4292

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

1 3910

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

iGate,

2 4679

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

iGate,

1 4776

how to sort date field in infomatica?

2 4852

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

1 3425

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 3224

HOW TO DELETE A RECORD FROM FLAT FILE

TCS,

6 10615

What are the challenges you have faced in your project?

Cognizant, Infosys,

1 14267

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

TCS,

2 7611

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

TCS,

1257


Post New Informatica Questions






Un-Answered Questions { Informatica }

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1485


How many input parameters can exist in an unconnected lookup?

244


What is powercenter on grid?

183


tell me the rules and responsblites in our project(my project is development)

1087


How to load a Dimension ? and how to load a fact table?

518






How we can create indexes after completing the load process?

197


Which version configuration tool used in ur project?

2306


How to load the data from people soft hrm to people soft erm using informatica?

182


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

220


What is lookup transformation?

190


What could be the possible resons of locks by user?

241


what is size of u r database?

1405


How many types of sessions are there in informatica.please explain them?

222


What is dimensional table?

182


As union transformation gives UNION ALL output, how you will get the UNION output?

205