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

Informatica Interview Questions

Questions Answers Views Company eMail

What is a design?

1 3753

How to delete duplicate records in a flat file source?

2 8562

What is a configuration management?

1 4066

How to send duplicates to one target and unique rows to one target?target is empty

Amazon, IBM, Wipro,

9 30619

what is the difference between lookupoveride and joiner?

3 7676

what is plsql table?

2 6273

how to declare array in plsql?

1 9347

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

Cap Gemini, IBM,

4 18055

How many cubes create from a single model?

1 4531

Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance

1 6023

how to join the two flatfiles using the joiner t/r if there is no matching port?

Cegedim,

5 13418

How will you display "Mr" for male & "Mrs" for female in target table?

7 12643

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 8715

How will you combine 3 different sources with a single source?

3 8460

how will you get 21 to 30 record from 50 records?

6 11534

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is exclusive and normal mode for repository services?

1063

What are multi-group transformations?

1013

What is joiner change?

1079

What is the use of source qualifier?

1073

Why filter transformation is an active one?

931

define galaxy repository in informatica

2157

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

7880

Explain the features of connected and unconnected lookup.

877

What is the format of informatica objects in a repository?

976

Can we create a node as a gateway node and the same node can be assigned to a grid?

1028

Explain the informatica workflow?

1005

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2802

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2142

How can one identify whether mapping is correct or not without connecting session?

1371

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1052

For More Un-Answered { Informatica } Questions Click Here