i have source data like
empno,enmae
11 ,aa
12 ,bb
i want output like
empno,ename
11 ,aa
12 ,bb
11 ,aa
12 ,bb
Answer Posted / amit
read the file from sequential file stage, use a transformer in between, write the same data to the same file using sequential file stage as target by setting option to - load file in append mode.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
which r the connectors used in san?
Name the different sorting methods in datastage.
How to reverse the string using unix?
What is the difference between odbc and drs stage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
what is the use of skid in reporting?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
How to read the length of word in unix?
What is the difference between Datastage 7.5 and 7.0?
How a routine is called in datastage job?
What all the types of jobs you developed?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also