@@@@calling All Datastage Developers@@@@

[mettastar]

Agreed ... nenu kuda starting lo okati rendu sarlu ilage cheste maa team lead painunchi kindidaka chusi routine raapinchadu ........okate dialog cheppadu naa tho " When ever You for a date with a girl , plan in such a way that you get to go out with her very often " ........... reusability concept --- Just code once so that its usable again and again and again @3$%

Andaru aa routines rayaleru kada ba.. and also u can make this code reusable.. oka shared container cheyi after splitting @OUTROWNUm from TFM. And u can plugin that shared container in any job.. if that's what u want.. idaithe debugging kuda easy kadha..

[mtkr]

bl@st

[mettastar]

[qwerty1204]

))(<

[nandamuribidda]

))(< ))(< ))(< ))(< ))(<

[mettastar]

[Silver_mani]

emaindi ...Evaru kanipinchatledu ...

[mettastar]

[Silver_mani]

mayya idi chudu

 

 

All, I have posted this before and successfully parsed the data as shown below.
Customer_id, Interaction_data
Adam, 12:10:07: Dialing12:10:07: Connecting12:10:07: ABC: abc:9433769781$100.88.77.0:878712:10:07: ABCD: 000012:10:07: Agent Initializing12:10:18: On Call12:10:18: Assigned to operator12:10:18: Waiting for Supervisor12:10:18: Waiting for Manager12:11:13: Call Ended12:11:13: Call Not connected

Now the parsed data looks like this,
Interaction_data
12:10:07: Dialing
12:10:07: Connecting
12:10:07: ABC: abc:9433769782$100.88.77.0:8787
12:10:07: ABCD: 0000
12:10:07: Agent Initializing
12:10:18: On Call
12:10:18: Assigned to operator
12:10:18: Waiting for Supervisor
12:10:18: Waiting for Manager
12:11:13: Call Ended
12:11:13: Call Not connected

The issue is that, each row has a customer id (Adam in this case) key for which this particular record is inserted. Now, If I want to add same customer_id to each parsed row, what method should I follow.

I want like,
Adam,12:10:07: Dialing
Adam,12:10:07: Connecting
Adam,12:10:07: ABC: abc:9433769782$100.88.77.0:8787
Adam,12:10:07: ABCD: 0000 and so one.

Appreciate your help.

PS- I can develop a parallel job for this, but this is a server job.

[mrudhula99]

yaa @gr33d

 

+1

[mrudhula99]

ee logic ni parallel job lo ela implement cheyali baa

 

I am writing to a fixed width sequential file, lets say of size 3 bytes and below is the sample data in the file

 

abc

pqr

mnc

xyz

4 

 

last line of the file lo aa file lo enni records unanyi anedi rayali in this example 4

 

and this has to be implemented with in the job scope (not using any command activity stage or after job routine)

Transformer lo @rownum?

[Laila2]

+1

hii mrudhula nice meeting u

[nook]

k

[mettastar]

Hey wassaap

[mastercheif]

DataStage baga commerical ayepoyindhi... kottha technology vethakadam start cheyyali