Interview Questions Answers in Data Stage, SQL Server

madan.r

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

Total Questions Posted # 9
Total Answers Posted # 2

Total Answers Posted for My Questions # 26
Total Views for My Questions # 66909

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

Questions / { madan.r }

Questions Answers Category Views Company eMail

which is the most complex job in your career? Please tell me answer?

IBM, Wipro,

2 Data Stage 7437

What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?

SLK Software,

5 Data Stage 10098

how many types of sorting the data in data stage?

BoA, IBM,

1 Data Stage 6838

how many types of remove the duplicate records?

Caterpillar,

3 Data Stage 11445

hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer

HCL,

1 Data Stage 3632

Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is Empno 1 2 3 4 5 6 7 8 9 10

Tech Mahindra,

5 Data Stage 10673

in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh

IBM,

1 Data Stage 4210

in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5

IBM, YCS,

3 Data Stage 6625

How to read 2nd highest sal from EMP table?

IBM, TCS,

5 SQL Server 5951

Answers / { madan.r }

Question { IBM, 7184 }

I/P

---

ID Value

1 AB
2 ABC
3 ADE
4 A

O/p
---
ID Value
1 A
1 B
2 A
2 B
2 C
3 A
3 D
3 E
4 A

Answer

please clarify the answer? Vinod

Is This Answer Correct ?

0 Yes

1 No

Question { SLK Software, 10098 }

What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?

Answer

pls example

Is This Answer Correct ?

0 Yes

1 No