Informatica Interview Questions
Questions Answers Views Company eMail

How do you load only null records into target? Explain through mapping flow.

1475

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??

544

Tell me about MD5 functions in informatica

509

Tell me about Propagate functions in informatica

510

How to update a particular record in target with out running whole workflow?

1140

How you prepared reports for OLAP?

1135

How you know when to use a static cache and dynamic cache in lookup transformation?

1323

Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

212

Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

209

Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

204

Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.

204

Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

206

Difference between task flow and linear task flow

205


Post New Informatica Questions

Un-Answered Questions { Informatica }

how tokens will generate?

1717


explain one complex mapping with logic? sales project?

6117


Whats the difference between informatica powercenter server, repositoryserver and repository?

656


How can we improve session performance in aggregator transformation?

654


Explain lookup transformation is active in informatica

648






What is workflow monitor?

582


How do you update the records with or without using update strategy?

645


What do you understand by a term domain?

655


where to store informatica rejected data?

658


What is workflow? What are the components of the workflow manager?

620


Differences between connected and unconnected lookup?

594


Explain how many types of dimensions are available in informatica?

574


What is olap (on-line analytical processing?

625


What is rank transformation?

560


What are active and passive transformations?

634