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
What is aggtorec restructure operator?
What are the important features of datastage?
What is apt_config in datastage?
Describe the main features of datastage?
How do you import and export data into datastage?
What is meta stage?
What are the steps needed to create a simple basic datastage job?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is active and passive stage?
What are the areas of application?
Define APT_CONFIG in Datastage?
How many areas for files does datastage have?
Notification Activity
What are the types of hashed files in data stage