vamsi krishna


{ City } chennai
< Country > india
* Profession * sf
User No # 71557
Total Questions Posted # 2
Total Answers Posted # 10

Total Answers Posted for My Questions # 19
Total Views for My Questions # 28573

Users Marked my Answers as Correct # 57
Users Marked my Answers as Wrong # 8
Questions / { vamsi krishna }
Questions Answers Category Views Company eMail

i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

Cap Gemini,

11 Data Stage 17825

one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?

IBM,

8 Data Stage 10748



Answers / { vamsi krishna }

Question { Polaris, 7171 }

I have a few records all are same structures data, I want to
store data in multiple targets how?


Answer

use copy stage , drag for multiple out puts

Is This Answer Correct ?    8 Yes 0 No

Question { TCS, 8645 }

A flatfile contains 200 records.I want to load first 50
records at first time running the job,second 50 records at
second time running and so on,how u can develop the job?pls
give the steps?


Answer

hi,
where we can get the rank function in datastag....

Is This Answer Correct ?    0 Yes 0 No


Question { Polaris, 20716 }

how to retrive the max(sal),deptno,empno in datastage?


Answer

hi,
u r absalutely write
but here the question is to retrive the empno also.....

Is This Answer Correct ?    0 Yes 0 No

Question { Polaris, 20716 }

how to retrive the max(sal),deptno,empno in datastage?


Answer

when the data is in seq file , how we can get?

Is This Answer Correct ?    0 Yes 0 No

Question { Polaris, 14572 }

my source seq file have
col1
1
2
3
4
5
6
7
8
9
i have 4 targets
t1 t2 t3 t4
1 2 3 4
5 6 7 8
9 like this how we can get?


Answer

hi,
srikanth

it 's not possible by using round robin , round robin can send recordes to nodes not to target..

if we can use collection methodes also we have 3 targets ,it's not possible

Is This Answer Correct ?    11 Yes 3 No

Question { Polaris, 14572 }

my source seq file have
col1
1
2
3
4
5
6
7
8
9
i have 4 targets
t1 t2 t3 t4
1 2 3 4
5 6 7 8
9 like this how we can get?


Answer

hi.,
srikanth

can u plz explain in detail...........

Is This Answer Correct ?    0 Yes 0 No

Question { CGI, 19640 }

What is RCP


Answer

run time column propegation

Is This Answer Correct ?    4 Yes 2 No

Question { 5123 }

3) Sequential file contains data like
Empno ename sal
111 abc 2000
Trgt file:
Trgt1----111
Trgt2----abc
Trgt3---2000


Answer

hi,
it's simple one only
take sourse----->copy----> t1,t2,t3

in copy stage we map the in put columnes to out put as we required like col1 to t1,col2 to t2,col3 to t3...

Is This Answer Correct ?    18 Yes 0 No

Question { Cap Gemini, 17825 }

i have a table
col1
10
20
30
40
10
20
50
my requirement is how to retrive only duplicates like
10
10
20
20
like this how it's possible in SQL?


Answer

HI,
ANY ONE TELL ME HO WE CAN DONE THIS IN DATASTAGE?

Is This Answer Correct ?    1 Yes 1 No

Question { IBM, 22370 }

source file contains 100 records, i want 10 records in
target file how it possible in datastage


Answer

take source --->trf---->trg
in transformer constaints put inrownum <=10
then u can get the required answer.........

Is This Answer Correct ?    15 Yes 2 No