DSXchange

start loop activity will check for single row in a file(delimited)i.e 1,2,3
here i have to pass Number as One Parameter
Filename as Another Parameter.

In the file it contains multiple rows
how can i extract each row(two column Values) one by one in loop

i have a job to write the below values to a file(delimited)

Number,Filename
1,File1.txt
2,File2.txt
3,File3.txt

How can i extract and pass the values into Startloop and Endloop activity.
do i need nested loop for this?
Please suggest me.

inputcolumn=+0000089.00

left(abc.inputcolumn,10)

im reading from sequential file where the amount column starts from position 1-10 and immediately followed by space. +0000040.00 so im reading as 11 bytes from source and doing left function to take only amount. when im reading im getting the below message. Numeric string expected for returned value...

next load we need to flow into target.
if we reject in the first load and the next day also will get reject.

Hi,

First run is the Initial load the records should not flow into the target.
for the next load records has to flow into target.

i have a attribute called code.

if the code is 1 then filter for the first run.
from the next run if the code is 1 then we have to flow to the target.

definitely there will be source issue.
please check the source file
try to split the files and load.

have a user variable activity and declare a variable

extract the date value from file

Make sure before user variable stage use exec command stage to display the value from file

i splited the records those which are joining and processed.
the records are getting joined.

e.g.
12 25.00 name
12 35.00 name1

when the above records process with other records the records not getting joined.it contains thousands of records.

e.g

code

12 25.00 name
15 34.00 name
15 44.00 name

i have convert the amount column as CHAR(Amount) in query.
but the records are not matching.

try this
Trim(Expresion,'-','A')

what about database is this the same DB or different.

If so please check the database level performance regarding reindex and indexes in tables which you are using and compare.

first for null values first and then go for NUM Function

If IsNull(Columnname) then setnull() Else ......

I have sort in DB2 Stage and after DB2 stage im using Transformer stage
the doubt is, will the same sort order retain in Transformer stage.
If not how can i retain the same sort from start to end

DB2stage----Transformer---Look Upstage----Transformer------Dataset