DSXchange

I have a source data col1 col2 12345-3 123 12345-1 456 12345-2 789 I have 3 lkp ( with id and seq number as key columns) lkp1 col1 col2 col3 12345 1 abc 12345 2 cba 12345 3 bca lkp2 col1 col2 col3 12345 1 abc 12345 2 cba 12345 3 bca lkp3 col1 col2 col3 12345 1 abc 12345 2 cba 12345 3 bca When there ...

Xfm1 ---> link collector ---> sequential file

there are 8 links coming out of tranformer--> i am collecting all of them using link collector(all have the same metadata) This is where i am missing rows of data --> then writing into seq file

I am missing couple of rows in link collector

Here is the job design

Xfm1 ---> link collector ---> sequential file

used this options:

Enable row buffer
inter process
buffersize 128
timeout 600 seconds

Would appreciate help from anyone

How get list all tables(Target) used in a project?

Its working fine with out pound/Hash sign

Thanks, I learned a new point

sequential file

i am passing the parameter to the derivation of a sequential file.

1. created a parameter in job parameter. 2. enclosed the parameter name in hash/pound its not accepting I double clicked the derivation->Browse->job Parameter (we get a list of job parameters) i select the created parameter. its with out a hash/pound sign Why is not working with hash/pound sign

How can i pass a DATE at run time to a column.

I want to use a parameter

chulett wrote:I personally would assume a typo in the FAQ posting.

Installation of Oracle9i is successfull, i need to set up TNSNAME.ORA and other file.

ArndW wrote:According to the Docs, only Oracle 10.2g is supported for the repository. ...

In FAQ the posting says we have have the flexibility of installing Oracle 9i.

viewtopic.php?t=114037&highlight=srimit ... 3355c14275

At version 8 the IBM Information Server Planning, Installation, and Configuration Guide documents most aspects of the installation including the database dependant ones. Those items that aren't covered can be read in the Connectivity Guide for Oracle Databases [/u]. What is your repository going to...

I am planning to install Datastage 8.0 version.

I am done with the installation of Oracle 9i, What configurations i am supposed to do in oracle.

Thanks in advance

TRY THIS.

IF ISNULL(TRIM(LINK.FIELDNAME)) OR TRIM(LINK.FIELD) = '' THEN @TRUE ELSE @FALSE

Hi all, My job looks like lookup | | source--------------->x---------->target In my source data column (A) 10 20 30 Look up data column(A) column(B) 10 name1 10 name2 10 name3 20 name1 20 name2 20 name3 My problem is when i do a look up i am getting only one record from the look up, But i am suppose...

Hi TYPE NAME C 300 A 100 A 100 B 100 A 200 B 200 D 500 B 600 E 700 I HAVE TO ERROR OUT THEM WHEN THE SAME NAME HAS DIFFERENT TYPES A 100 A 100 B 100 I HAVE TO ERROR OUT THEM WHEN THE SAME NAME HAS DIFFERENT TYPES A 200 B 200 How to solve this, i have tried using RowProcCompareWithPrevious value. Any...