3) Sequential file contains data like
Empno ename sal
111 abc 2000
Trgt file:
Trgt1----111
Trgt2----abc
Trgt3---2000
Answer Posted / vamsi
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 |
Post New Answer View All Answers
how to abort the job its matain duplicates?
describe the Steps to confiure a Qlogic switch
What is the roundrobin collector?
What are the components of ascential data stage?
On which interface you will be working as a developer?
How to read multiple files using a single datastage job if files have the same metadata?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
Name the command line functions to import and export the DS jobs?
Is possible to create skid in dim,fact tables?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Lookup constraints
What is the project in datastage?
What is "fatal error/rdbms code 3996" error?
What are stage variables, derivations and constants?