What is SCOPE_IDENTITY() in sql

what is service oriented architecture in Informatica 8 version

1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?

i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact tables in a report?

what is a force compile

are we use the group by clause in cursors?

what is the differences between spufi and qmf and which is better?

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

How to know the perticular record in pf with out reading?

how can i know logical file belongs to which physical file without source?

what is open data path? and what is the diff b/w access path and open data path?

How many types is controls is there in Asp.Net?If it means what are types of custom controls?Explain about user controls,Web server controls,Hrml server controls?

diff b/w layout calculation and query calculation

1) what is synchronization? 2)write a program to show synchronization ? 3) what is orm? 4) what is getTemplete method and hw u use it? 5)write a singleton program ? 6) what is IOC concept & explain it? 7) methods of spring? 8)explain spring framework? 9)what are the oops concept? 10)what r the diff types of exception? 11)what is AOP(assepct oriented programing)? 12)jsp life cycle? 13)servlet life cycle? 14)how to u catch ur exception when executing a query in hibernate? 15)write javascript function? 16)write a querry to join two tables? 17)wap to show inheritance and use of interface? 18)explain the project? 19)in spring bean class uses singleton or prototype? 20)Explain prototype?