i have input like this
Column 1 ,column 2
3,a
4,b
5.c
i want output
aaa
bbbb
ccccc
Ple help any one?
Answers were Sorted based on User's Feedback
Answer / satish
Hi
First read the data in sequential file,
then take transformer stage create a stage variable.
In stage variable
Str( DSLink2.column_2, DSLink2.Column_1).
Drag and drop the stage variable to required output column,
finally load the data in target.
Is This Answer Correct ? | 14 Yes | 1 No |
Ex:
Str( "a", 3)---->aaa
Str( "b", 4)---->bbbb
Solution:
use below transformer Logic in Output Col Derivation:
Str(DSLink2.col2, DSLink2.Col1)--->Output_Col(Output Column)
Output:
Output_Col
aaa
bbbb
ccccc
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / naresh
Hi All plz saw the blow
first we read the data in seqential file
then taken transformer stage in tr stage we are create the two stage variable first stage variable like
column2 : colum1
then stage variable like
str(left(stage1,1),Right(stage1,1))
out put dragan drop the stage variable
finally load the data in target.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / geetha
use str function in datastage. str(dslink.column1,dslinkcolumkn2). In the output we get the required data . str function is used to repeat the column number of times.
Is This Answer Correct ? | 2 Yes | 2 No |
what is the exact difference between dataset and fileset in datastage?
job locking methods? How can we unlock the job?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
client know skid info?
What is meta stage?
Name the different types of Lookups in Datastage?
My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
How to Remove Duplicate using SQL?
what is the unix script to run the job? Please mention commands which we use often?
what is the use of skid in reporting?
How do y read Sequential file from job control?