COOLINTERVIEW.COM MICROSOFT ASP.NET 2.0 DETAILS

Question :

1.How to enter same record twice in target table? give me syntax. 2. How to get particular record from the table in informatica? 3.How to create primary key only on odd numbers? 4. how to get the records starting with particular letter like A in informatica?

Answer :

Declere Target table twice in the mapping and move the output to both the target tables. Ans4: select name from tablename where name like 'A%';  Posted by: Mukesh       Contact Author bowlaaaaaaaaaaaa! is the correct answer  Posted by: mathey       Contact Author ans 4 select * from emp where ename like 'A%'  Posted by: kiran       Contact Author 2. select * from <tablename> where <coloumn-name1>='<value>'and <coloumn-name2>='<value>'.........  Posted by: Devendra Singh Bhadoriya       Contact Author 1.How to enter same record twice in target table? give me syntax. A)To insert a same record in to the target table twice, use the fill method of dataadapter twice and update the dataset add the following lines of code sqlconnection cn = new sqlconnection("ur connection string"); Sqldataadapter da= new sqldataadapter("select * from sometable",cn); sqlcommandbuilder cmb = new sqlcommandbuilder(da); dataset ds= new dataset(); da.fill(ds,"sometable"); ds.tables[0].constraints.add("usr_pk",ds.tables[0].columns[0],true); datarow row; row=ds.tables[0].newrow(); for(int i=o;i<2;i++) {i++; row[0]=value; ds.tables[0].rows.add(row); da.update(ds.tables[0]);  Posted by: mahesh       Contact Author © CoolInterview.com Today's Special: Get Free Magazine from SAP now! A D V E R T I S E M E N T

If you have the better answer, then send it to us. We will display your answer after the approval.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code:*
	Inform me about updated answers to this question

   

Category	ASP.NET 2.0 Interview Questions
Rating	(0.0) By 0 users
Added	8/18/2006
Views	1070
Rate it!	* * * * * * * * * * * * * * *
Free Offers	300 Free Magazines for you. No credit card required. No Shipping Charges. Absolutely Free for 1 Year.

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email: