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?
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
What is the difference between odbc and drs stage?
How do you generate sequence number in datastage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
How do you reject records in a transformer?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How a server job can be converted to a parallel job?
How can we improve performance of data stage jobs?
Triggers,VIEW,Procedures
Notification Activity
Explain Quality stage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What are some different alternative commands associated with "dsjob"?
how to write server Routine coding?
To see hidden files in LINIX?
On which Dimension Table you implemented SCD Type in your Project