Interview Questions Answers in Informatica, SQL Server

satyabrat nayak

{ City }
< Country > india
* Profession *
User No # 101012

Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 5
Users Marked my Answers as Wrong # 0

Questions / { satyabrat nayak }

Questions Answers Category Views Company eMail

Answers / { satyabrat nayak }

Question { Cap Gemini, 9646 }

My source data like...

Empid Name
10 chandra
10 sekhar

I am expecting result is

Empid Ename
10 Chandrasekhar

How can we solve this prob?

Answer

USE WM_CONCAT() FUNCTION

Is This Answer Correct ?

0 Yes

0 No

Question { IBM, 6918 }

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

Answer

yes, we can,,create a child sp inside a parent sp...

Is This Answer Correct ?

5 Yes

0 No