DSXchange

Hi, So how can i avoid first five rows to sourch while importing... Use the Filter option in the Sequential file stage. If you know the number of rows in your file (200 in this case) you can give Tail -195 in the filter and this will read only the last 195 records from the file. But is the number o...

Can you try doing a trim of your string before giving it to the conversion function - and let us know if the warning still persisits?

Does it mean that your Master Source file has data for all the 3 types in varying metadata - say type1 has 137 columns, type2 has 83 columns and type3 has 67 columns? - and all this in a single file? You might want to read it as a single column and then split it into different columns using the Colu...

can you please tell me what is this :- sequential funnel, if your requirement is that, other wise go for continous funnel . Inside the Funnel, you have options for Continuous, Sequntial or Sort. Continuous Funnel combines records as they arrive (i.e. no particular order); Sort Funnel combines the i...

There is also the File Name option in the Sequential file stage which lets you have an additional column in the metadata with the file name as the value inside.

Nageshsunkoji wrote:You can parameterize Servername,Schemaname,username and password and I don't think so database name is required in the parameterisation.

We have jobs with all parameters other than table name.

I believe the question was with regard to the parameterization of the Scema name from the SQL builder.

asitagrawal wrote:Ok...
One More thing, when I click on Help, the Help opens in some language other than English. So u get help in English (am asking only for SQL Builder Help)...

Thx anyways

There is a chapter on the SQL Builder in the Parallel Job Developer's Guide.

Working:- sequential file --- transformer --- sequential file2 ---- job1 seqfile2 --- transformer --- sqlserver ---- job2 To make it as a one job can you suggest some tips: sequential file --- transformer --- sqlserver ---- job1 Not sure if I am missing something here - but can't you not simply rep...

I am not sure if you can parametrize the schema name from the SQL Builder - though you can include parameters in the WHERE clause from here.

But why dont you use the Custom SQL query - where in you would be able to parameterize as you wish?

Aneesh

Never worked on 7.5.x2. But is this happening in the Job Activity? Meaning - are you not able to see the job in this activity?

Doesnt seem to be an issue in 7.5.1 - as I can see such jobs in the Job Activity.

Aneesh

Hi, I think, these are all because of resource allocation to the jobs for monitoring the data. We have environmental variables called APT_MONITOR_SIZE and APT_MONITOR_TIME. These variables will lead the monitoring functionality in Data Stage. overridden the default setting with values, set APT_MONI...

[quote="thebirdBy passing the same configuration file to the parameter in the second job.

[/quote]

If you dont want to run the Second job with the same config file, then use another configuration - but one which will include all nodes that were used in the creation of the dataset.

Aneesh

santoshkumar wrote: how can i overcome that.

By passing the same configuration file to the parameter in the second job.

Since the dataset was created with a different configuration - if you have to read it - you would need a config file that will have the nodes which were used to create the dataset.

Aneesh

vij wrote: I am using the xml ouput stage in which i am writing the output to a file by specifying its path.but the file is not created in the specified path..

Please provide more details. Does the log give any warnings?

Why dont you use the same configuration file that created the dataset , for the second job? The issue might not exactly be becuase you are using a different config file. It might be because - for the second job you are tyring to use a config file that does not include the nodes that were used to cre...