Accenture telephonic Interview Questions (6-06-2011)

1.whandot is the diff b/w 7.x/8.x?

2.what is the sql transformation and explain?

3.what is domain and node?

4.what is the use of associated port in lkp transformation?

5.what is the diff b/w sql source qualifier and flatfile sourcequalifier?

6.I have 1000 flatfiles i had already loaded 700 flatfiles how to you load remaining 300 flatfiles?

7.i have to load 1 lakh of records to the production system in b/w the session
fail what u can do(u can't restart,and also u r not assiging session to a recovery mode)?

8.how can u migrate the code from developed environment to productionenvironment?

9.which type of scd2 can u use in ur project?

10.if ur source data contain no duplictes and also u don't want to perform incremental agrregation
and no need of sorting the data then what is the use of sorter t/r before aggregator?

11.my parameter file dosen't contain any value then how the integration service executed the parameter file?

12.if ur using mapping variable and run the session if the session fails then what is the value in repository?

13. what are the reusable tasks ur used?