DSXchange

Did you try to figure this out, I am having the same issues, it reverts to DB2, even after using ORACLE.
Is it a bug?

For SCD, (with my limited understanding is that), my reference link should have the latest updated row for the next row to see if its a new or old record. I am not sure if it can update the target and do a lookup on the same (Similar to the one we do in Server, using a transform and dynamic HASH fil...

Note sure if this is asked before (could'nt find it in the search) ---- -SCD-II(slowly changind dim) change for customer -I will be pulling from a DB which have multiple changes within a day eg: customer data changes 5 times a day at the source -I will be pulling data once End of Day(EOD), for all t...

Wanted to check on you experts who are using SCD stage in projects for 8.0/linux: (I understand that there are lots of posts about various SCD issues/topics) -Want to know if there are issues in basing the datamart etl design purely on the SCD stage (type-1 or type-2) -are there any known bugs or od...

I am trying to write Japanese double byte data to dataset. I only see "???" instead of data using view data on dataset. Is this a problem of view data or the data itself, any way to see dataset data from .ds file? I am able to write the same data to a unicode db or a UTF-8 flat file and se...

Can we do something with RCP?

Columns in Dataset#1 :(DS#1) col1 col2 Columns in Dataset#2:(DS#2) col1 col2 col3 Can I have a common job which reads both the formats of DS#1 and DS#2? (2 different instances of the multi instance job below) These will be used as " inputDS " only, without joining them job flow example: in...

Is there any option to ignore dependent components. I want to export job and exec
Any thoughts?

I know this is a late reply...hope this will help someone...

I tried using just the parameters (not the parametersets) and they work

So, I guess this is in a Transformer-stage. We can use a file or a database to get a unique number. If I can refer to the same file, i can get unique values - controlled centrally by the file. Will there be any lock on the file? The jobs will be running in parallel...so multiple jobs will be trying ...

Issue: We want to create a UNIQUE surrogate key across jobs in datastage.(not with in a job) Can we: As per my knowledge, in informatica, we can have a global counter and use it if we want the next-number. (project level) This will make it unique in a project. Is there something in datastage for th...

Can I use the following in any of the ODBC/Informix stage: (2 columns) Tbl, a - are the column names coming in to ODBC/Informix stage. insert into ? values(?) OR insert into orchestrate.Tbl values(orchestrate.a) I am trting to subsitute the ? with the corresponding value from the data. Please advice.

It allocates 1000 SK's for each partition.

Will there ever be a case when they overlap or will it keep track of the blocks (1000 SK's)?

Do you guys see anything wrong in this default.apt. I tried to run seq gen stage in parallel and it gives me duplicate keys. node "node1" { fastname "SMIMetlt001mgt" pools "" resource disk "/data/DataStage/datasets" {pools ""} resource scratchdisk &q...

I am trying to view data using the imported copy book which has OCCURS. When the DS imported the metadata, some of the groups count (length) is not matching the total fields length of that group eg: GROUP 5 field 10 The metadata has imported the OCCURS column as defined in the copy book. When import...