Ex: Str( "a", 3)---->aaa Str( "b", 4)---->bbbb

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?

Question Posted / subbuchamala

4 Answers
14050 Views
SLK Software, I also Faced
E-Mail Answers

Answer Posted / subbuchamala

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is merge stage?

1228

What is the difference between orabulk and bcp stages?

969

What are the important features of datastage?

1051

Difference between in process and inter process?

1164

What is the difference between Datastage 7.5 and 7.0?

1050

What is the different type of jobs in datastage?

902

How to reverse the string using unix?

3432

What are the functionalities of link collector?

1038

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2822

What are the various kinds of containers available in datastage?

976

How one source columns or rows to be loaded in to two different tables?

1072

Name the different sorting methods in datastage.

991

Terminate Activity

1234

What is the purpose of pivot stage and types of containers in datastage

996

What are some different alternative commands associated with "dsjob"?

1082