DSXchange

Hi Just read that a Lookup can have multiple references for an incoming stream of data to be matched. My question [might sound silly]: [1] Should the key to the Incoming data and all the reference be the same [in cases, where references are from multiple sources] ?? OR [2] for each Reference can the...

The only good option is to use Usage Analysis to determine in which jobs the table definition is used. Re-import the table definition then manually edit the links where that table definition is used, ... Thanks Ray. I would try out Usage Analysis to get a grip of changes that may be needed. Otherwi...

What about that? Add transformer after Agg and add dummy columns inside to sync all inputs before the Funl. Thanks Kris and Ray..and I would try out the Col Gen, though I was skeptical abt the COPY stage. Pigpen, I have bunch of Aggregators[20+] for different purposes, and don't want to burn myself...

ray.wurlod wrote:Fairly sure that it will not install, and that this is picked up by the InstallShield wizard. ...

Thanks Craig and Ray

The inputs to the Funnel stage needs to have identical(exact) metadata. So, your job desing won't work unless you are bringing out all the columns from all the aggregators which I doubt it. You could use a join stage or Merge stage followed by a Transformer. Thanks. I have bunch of Aggregators, and...

ray.wurlod wrote:Extra memory on the client will help when compiling job sequences. ...

Thanks RAY, memory either 512MB/1GB was on my mind anyways, but how about the other configuration my machine has. Can the Win Home XP be clarified, if anyone has faced an issue. Thanks in advance

Hi, My Input Fields are FLD-1,FLD-2,FLD-3,FLD-4,FLD5,FLD-6,FLD-7 AGG1 Groups on FLD-1 sums on FLD-4 & FLD-5 AGG2 Groups on FLD-1,FLD-2 sums on FLD-4 & FLD-5 AGG3 Groups on FLD-1,FLD-2,FLD-3 sums on FLD-4,FLD-5,FL7 Can I FUNNEL the AGG1,AGG2,AGG3 output into one as Output File layout [similar...

If we try to get the metadata of the cobol copybooks using DS manager-> Import -> Table Definitions -> Cobol File Definitions does it expect .cfd files, if yes, how to obtain the .cfd files. All I have is the copybooks in .txt format I am interested too in knowing this...If there's a change to Meta...

Hi, I have COBOL FD table definitions and LOAD in each of the STAGES. If I need to add another field to these table definitions, how would I go about reflecting the latest change to all STAGES that refer it? Is the only option, going to all Stages that use these definitions, and manually do the upda...

Hi, My home pc is Dell DIM3000/Windows XP/Home Edition/Intel Celeron Processor 2.4GHZ and 256MB RAM. To have DS Client Installed and run efficiently, apart from increasing my 256MB to 1GB or so, would there be any limiting factor in my computer's configuration ???Would Celeron be a concern !? Any th...

Vincent Loved the blog on DataStage Simplicity. Very cool. My thought process completely. DwNav and all my tools are aimed at reducing the complexity of ETL to help understand the overall data flow within ETL. Simplicity also means consistancy. ParameterNavigator is aimed at consistancy and simplif...

Well spotted, it's not necessary. I was solving a different problem. The aggregator stage will generate: Groupkey1,Groupkey2,Groupkey3.....Amt1,Amt2,Amt3.... 1111,2222,3333.....$20,$8,$5 2222 ... Thanks all for suggestions, [though some answers, I can't see in full]. But my question is Would it be ...

Hi, For the same group key in an aggregator, would it be possible to aggregate multiple columns in a record into one output column. e.g Input Groupkey1,Groupkey2,Groupkey3.....Amt1,Amt2,Amt3.... 1111,2222,3333.....$10,$5,$3 1111,2222,3333.....$15,$3,$2 2222,3333,4444.....$1,$2,$3 2222,3333,4444........

Thanks keshav, i will try that tomorrow and let you know how it goes. And Finally can i conclude that each column that is passed through aggregator has to be either grouped or aggregated???? Yes..anything from the Input of Aggregator to get to Output of Aggregator should either be GROUP column[s] o...

There's a logical inconsistency in your question. If it's static then surely there's no need to update it? Am I missing something here? ... Sorry if I had not been clear. Say I have a reference file, which is going to be static e.g., Item# 222222 Description: Pencil which next month could be PEN . ...