difference between source based commit? and target based commit? which is better with respect to performance?
IBM,
6 17123Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com
1 3736If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
3 7974Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---
1 7061working with Business Objects 6.1(a), i m facing a problem. when i save the BO report containing chart aswell as table in .xls then the null vlues in the table automatically are converted to 0, thereby istorting the chart also. please provide me the solution as soon as possile.
1 3917What would the following datastep do? Data _null_; Set Dist end=eof; Call Symput("xx"!!left(put(_n_,2.)),&dimension); If EOF then Call Symput('numrows',left(put(_n_,2.))); Run; dimension is a macro variable that is being passed here
2 5475if we increase the number of dimensions will the rows in fact table increase or decrease??
IBM,
3 8095How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
1 3471How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
IBM,
1 4769Business rule implemntation depends on? 1.)ETL requiremnts 2.)ETL performance 3.)business requirements.
4 6643
where to store informatica rejected data?
How do you add a number to a macro variable? : sas-macro
What do you mean by caching in teradata?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
What are the some differences between 7.x and 8.x version of datastage?
What are the modules in Power Center
What are the types of facts in microstrategy?
Define bulk load mode?
What is the difference between connected and unconnected stored procedures?
What are the steps involved after the disk manager passes the request?
Can you connect multiload from ab initio?
What are the types of lookup transformation?
how many types of viewers available in tm1?
in sap bi we have wad, then why we go for sap bo