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

Informatica Interview Questions

Questions Answers Views Company eMail

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

Wipro,

1 7157

Issue with Update override at Target table in Informatica.

2 8592

Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

DELL, TCS,

5 12898

Hi experts, can anyone tell how much we use plsql in real time

3 6683

Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

Infotech,

2 9124

Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 5703

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

BRAD, TCS,

8 12363

In target table how to display the system time

1 4588

source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

IBM,

1 3956

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

IBM,

3 6844

what is correlated query?

IBM,

2 5767

what is inline view?

IBM,

1 5245

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

PayPal,

2 15847

what is data driven in update strategy transformation?

HCL, PayPal,

2 17145

what is system requirement(SR) & business requirement(BR)?

Ness Technologies,

2 6482

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain in detail about scd type 1 through mapping.

1307

How can you generate reports in informatica?

982

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

1073

Explain how to import oracle sequence into informatica?

964

State the differences between sql override and lookup override?

1127

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2199

Performance tuning in UNIX for informatica mappings?

2523

What are connected or unconnected transformations?

1058

Explain the scenario which compels informatica server to reject files?

1102

what is the size of your data warehousing?

2054

Explain constraint based loading in informatica

1050

Why filter transformation is an active one?

941

How to create a non-reusable instance of reusable transformations?

1065

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

7919

What are the new features of Power Center 5.0?

1714

For More Un-Answered { Informatica } Questions Click Here