DSXchange

But how are limiting the output? Each time in your examples, you are only showing one output but you have said that its possible the constricting value could be 'source' or 'select' or many others. How are you determining which value the output is to be restricted by? Ie Are you only ever wanting o...

[quote="prasad111 ... my conclusion will be that it is not possible to implement the above question using only one HASH FILE, It can be done with one hash file - but you would just have to refer to that one hash file 30 times. :) However - i am just wondering if I understand what you are tryin...

Fundamental Principle It is not possible to combine rows from multiple sources unless there is some common factor, without generating a Cartesian product. A Cartesian product contains M * ... Thanks for the reply, As per your comment my conclusion will be that it is not possible to implement the ab...

Hi, If you create a hashed file for Table2 with a composite key consisting of ( col1, col2, col3 and col4) Then you would have all the records. Now coming to the transformer of the job. Perform the lookup, by joining, colA to col1 '1' to col2 'source' to col3 colB to col4 I'm thinking this would wo...

I_Server_Whale wrote:Hi,

What are the keys for table 1 and table 2?

Thanks,
Whale.

In Table 1, col A is the key and in Table 2, col 1 is the key.
(NOTE:Table 2 is manually entered and maintained table)

You can write table 2, to hash file with Key as col4. Do a look on T1MainStream.colb = T2LkupLink.col4. and later in stage variable, have Not(T2LkupLink.NOTFOUND) AND (T2LkupLink.col3 = source)) then table 2.col5 else "" If I use key as col4 in table 2 then the duplicates will be removed,...

Is the value of table2.col3 literally 'Source'? If so select the values from that table into a hash file with two columns. Use a query like select col4, col5 from table2 where col 3 = 'source' On the hash file set the first column (col4) as the key. Link this column to your input table. If hashlook...

I am having tough time with lookup, table 1 ---------------------------- colA | colB | col C | col D ---------------------------- 1 | A | 1946 |jlk 2 | B | 946 |jlk 3 | A | 46 |jlk 4 | B | 6 |jlk 5 | A | 1 |jlk 6 | D | 146 |jlk 7 | E | 196 |jlk ---------------------------- table2 -------------------...

narasimha wrote:Have you linked the key from the hashed file lookup to the source table column?

They use this

Code: Select all

if LookupLink.NOTFOUND then '**' Else SourceTable.State 

It is working, it was mistake from my side.

Thanks a lot

Compared to what? Why don't you do the research and let us know. Without tying up resources, we could only supply a theoretical answer in any case. ... Other way of achieving was hardcoding it, I checked out for running this job for 50,000 records with hardcoding it took 12 min with hash file it to...

How can you do a lookup without a key ? - Create a hashed file from your lookup table with stt_cd as key (Use this as a lookup) - Now when you dont find a lookup replace with '**' else let the column flow through Ex : if LookUp.NOTFOUND then '**' else SourceTable.State Get back if have problems doi...

Can you use a stage variable to do a replace on the incoming row? Basically check to see if the incoming column is "ALL". If so replace the row with a concatenation of the 3 required rows separated by a line seperator. ie variable output would be something like ColA:'|':ColB:'|X|':ColC:Ch...

I have two tables source table has ----------------------------------------- address1 | city | state | zip ------------|---------|-------|----------- 123 main | newark| NJ | 12310 3434 | sanjose| CA | 54540 1232 | ASJK | AI | 4454550 ----------------------------------------------- NOTE: In the above...

We have master sequence activities which call another set of sub master sequence activities and these sub master sequence activities call the jobs. The problem that we are facing from thelast 2 months is that the jobs froze (not the same but different places). Previously we had this probelm once in...

Hi, Please help me in doing this. --INPUT RECORDS ------------------------------------- ColA|ColB|ColC|ColD A1 | A2 | ALL |A4 B1 | B2 | B3 |B4 C1 | C2 | C3 |C4 ----------------------------------------- Whenever I found the word ALL in ColC, I have to create a new 3 records, the value of ColA, ColB a...