Interested to Buy Any Domain ? << Click Here >> for more details...
Hi I have scenario like this
s/r table T/r table
ename,sal empno,ename,sal
vijay,2000 1 , vijay, 2000
kumar,3000 2 ,kumar , 3000
ravi ,4000 3 ,ravi , 4000
How can i get target table like that without using
Transformer stage?
- 8 Answers
- 13528 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answer Posted / ramachandra rao
first of all question is not clear
ok fine
if u take source as sequential file there is one option is
there i.e rownumcolumn use this option it will create
sequnce number.
2.use columngenerator also we used
Thanks
chandu-09538627859
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How you can fix the truncated data error in datastage?
What are the types of containers and how to create them?
What is the use of hoursfromtime() function in transformer stage in datastage?
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 the different type of jobs in datastage?
What are the various kinds of containers available in datastage?
How many types of stage?
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
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is the difference between datastage and datastage tx?
What is "fatal error/rdbms code 3996" error?
What is size of a transaction and an array means in a datastage?
What are the different plug-ins stages used in your projects?
Difference between server jobs & parallel jobs?
