Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 14214 Views
- SLK Software, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
what is flow of project?
What is the difference between odbc and drs stage?
What are the different common services in datastage?
Define orabulk and bcp stages?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
If you want to use a same piece of code in different jobs, how will you achieve this?
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.
Can you explain kafka connector?
Describe the main features of datastage?
describe the Steps to confiure a Qlogic switch
Can you explain tagbatch restructure operator?
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 merge stage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
