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

Different types of Power center errors?

Cinterco, IBM,

1 6867

Define Update Override?

1 3630

Define error Threshold?

1 3818

Examples of Fatal & Non-Fatal error?

Cap Gemini,

2 18953

Difference Between ETL & ELT?

TCS,

1 6605

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 5578

Define Incremental Aggregation?

2 4788

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

Wipro,

3 7185

Can we use parameters of parameter file in presession command

Wipro,

1 5980

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

HCL,

4 7083

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

Accenture,

1 3960

What is galaxy shema

CGI,

2 5545

which one is better either active or passive transformation in informatica

1 3866

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1513

What is the difference b/w natural key and surrogate key

1 4439


Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain pushdown optimization $pushdownconfig parameter - informatica

508


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

434


What is rank index in rank transformation?

449


How do you set a varible in incremental aggregation

1240


What the difference is between a database, a data warehouse and a data mart?

445






Explain about Informatica server process that how it works relates to mapping variables?

460


Which transformation should we use to normalise the COBOL and relational sources?

543


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

351


What is workflow manager?

405


Define sessions in informatica etl?

469


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

407


Can we create a Integration service without a Repository service and vice versa?

509


Can informatica load heterogeneous targets from heterogeneous sources?

495


What are the issues you have faced in your project? How did you overcome those issues?

1749


What is the difference between source qualifier transformations source filter to filter transformation?

412