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
498Q. 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.
489Q. 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.
526Q. 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.
590
If informatica has its scheduler why using third party scheduler?
Is it possible to define a single node as a Gateway node as well as worker node?
What does cheating measurement mean?
What is the difference between agglomerative and divisive hierarchical clustering?
How were the reports scheduled and how to resolve unexecuted documents?
How to call shell scripts from informatica?
What do the SAS log messages "numeric values have been converted to character" mean?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.
How can you force the optimizer to use a particular index?
What are the considerations regarding performance kept in mind while setting up cognos?
what versions of sas have you used (on which platforms)? : Sas programming
Explain the various types of filters available.
What is informatica powercenter repository?
How to delete data which is not in source table?