anat


{ City } haryana
< Country > india
* Profession * developer
User No # 74773
Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 9
Users Marked my Answers as Wrong # 2
Questions / { anat }
Questions Answers Category Views Company eMail




Answers / { anat }

Question { 6436 }

in one scenario source flat file like
Fileld1
00122001550056200568
00256002360014500896
00123004560078900258
00147004560025800256
divide each 5 numbers as one column i.e
here i need
field1 field2 field3 field4
00122 00155 00562 00568
00256 00236 00145 00896
00123 00456 00789 00258
00147 00456 00258 00256
plz help me....


Answer

Hi as per my knowledge pls follow the below steps
1)take entire source as single colom
2)in transfomer split that colom in to multiple coloms by
using substring or field functons

Is This Answer Correct ?    2 Yes 2 No

Question { IBM, 7716 }

i have data like
sam
ram
sam
raj
ram

I want two targets
trgt1
ram
sam

trgt2

raj
how can i do this in datastage?


Answer

src.....>agg........>t/r..........2trgs
take src as seqfiles and take aggregater stage is for
calculate count of records based on name coloumn,next take
the transformer is for apply constraints like cnt=1 then go
for trg1

Is This Answer Correct ?    7 Yes 0 No