3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt f

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

Question Posted / prasad

2 Answers
5982 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

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

Answer / sindhu

transformer field function

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More Data Stage Interview Questions

What are the different plug-ins stages used in your projects?

0 Answers

What are the different layers in the information server architecture?

0 Answers

2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?

1 Answers

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers UHG,

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers CTS,

Explain the datastage parallel extender (px) or enterprise edition (ee)?

0 Answers

Differentiate between data file and descriptor file?

0 Answers

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 Answers

i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring

13 Answers Bank Of America, IBM,

how to define satge variables in transformer stage

2 Answers

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

1 Answers HCL,

how to do pergformence tuning in datastage?

4 Answers MCA, Symphony, TCS,

For more Data Stage Interview Questions Click Here