DSXchange

naveenkumar.ssn

hi Do you mean to say you have a rownum column in a sequential file and you wanted to take the first 10 records from the file..if so you can specify head -10 {FileName.txt} ..It will fetch you the first 10 records..However if you dont have a rownum column and wanted to take the first 10 rows from th...

naveenkumar.ssn

Hi

Use the stage variable in order to do the following logic

Stage var1: To get the date field alone ...Use the field function and get the first field ( by default field has got space as delimiter)

Stage var1: Hard code to 00:00:00

Concatenate the two stage variable

Regards
Naveen

naveenkumar.ssn

Hi all, We are using Data Rules stage , after binding the variable from the input when you click on the Binding variable in the right hand pane in the Data Rules Stage. We are getting a error like a window pop up saying "An error has occurred in the script of this page" Line:219 Char:8 Err...

naveenkumar.ssn

Hi , Yes you are correct you will not have the invocation id in the display part of the director, however you can find it in the " Summary of sequence " in the director log. Moreover in your jobactivity when you call the invocation id as 'jobactivity1.jobname' it include the invocation id ...

naveenkumar.ssn

Code: Select all

IF isnotNull(FROM_ACCT_NUM)
   then right(FROM_ACCT_NUM,2)
    else if 
          isnotNull(FROM_ACCT_NUM)
          then right(FROM_ACCT_NUM,2):'XXXXX' 
   else if 
          isnotNull(FROM_ACCT_NUM)
          then left((right(FROM_ACCT_NUM,2):'XXXXX'):FROM_ACCT_NUM,12)    ELSE
 FROM_ACCT_NUM

naveenkumar.ssn

Hi,

This can be performed using schema files in datastage.

Create the schema file for the target as per your requirement.

Regards
Naveen

naveenkumar.ssn

hi Abyss,

you can do the SCD with the Change Data Capture,chksum and column export stages.

However before that can you please elaborate on whats your problem ?

With the post that you have given , we could not infer what is wrong ?

Regards
Naveen

naveenkumar.ssn

Hi Srinath,

your requirement is little confusing.

if you dont mind can you elaborate it more clearly.So that we will try to give you our solution to your problem.

Regards
Naveen

naveenkumar.ssn

hi ,

you have to be more specific on whats happening.

What do you mean by when you are trying to run the job, are you speaking about you clicked the run button and it does nothing? Is that what you mean ..btw ..did you try to execute it through dsjob command ???

Regards
Naveen

naveenkumar.ssn

Hi,

Yes its working.

I hope the one who created this thread can look upon the above solution to fix his problem

Thanks

Regards
Naveen

naveenkumar.ssn

Hi you have to use stage variable in the transfomer to get this done.Which I think is the easiest way to perform(though !!! there are lot of ways) In the transformer have 4 stage variable Assign a stage variable 1 = cntvariable as 0 prevrec=currentrecord currentrecord={ the input from the source} Sa...

naveenkumar.ssn

I have concatenated as mentioned below Start,End,Start_End,End_Start,Distance Bangalore,Mumbai,BangaloreMumbai,MumbaiBangalore,1500 Hyderabad,Delhi,HyderabadDelhi,DelhiHyderabad,2000 Delhi,Hyderabad,DelhiHyderabad,HyderabadDelhi,2000 Mumbai,Bangalore,MumbaiBangalore,BangaloreMumbai,1500 How to use ...

naveenkumar.ssn

Anybody help on how to proceed? Hi, Step1: First sort the rows where you wanted to check with Example : a b 100 b a 200 After you sort the above records it would be like the below: a b 100 a b 200 Use the remove duplicate stage to get either the first record or the second records.(Keep those 2 colu...

naveenkumar.ssn

hi

I tried with the unix environment, I could not find this issue.

However not sure with the windows environment.

probably my turn around would be concatenate all the files into a single file using before job sub routine.

Many Thanks

Regards
Naveen

naveenkumar.ssn

Hi If you have a database , then you can place a column as count and load the highest record count in the table and then read the column with max count +1 ..or if you dont have a database create a file and the load the max count value in it along with a dummy join column(name it as 1) .use a join st...

DSXchange

Search found 36 matches

Re: rownum for a record

Re: Time stamp Issue

Error occurred in the script - undefined or null reference

Re: How to concatenate two parameter and pass as Invocation

Re: Logic required for IF and else in tranformer

Re: Split a source file into multiple files dynamically

Re: SCD stage keep adding unchanged records into table

Re: Unable to run the datastage jobs

Re: Generate sequence number for the same group

Re: Generate sequence number for the same group

Re: File pattern was specified this indicates the pattern

Re: How to continue to increment a number