DSXchange

chulett wrote:Time to involve your official Support provider, it seems.

Yes i did Criag now..Let see...I will post the solution once they solve it....

g_rkrish wrote:

chulett wrote:Time to involve your official Support provider, it seems.

Yes i did Criag now..Let see...I will post the solution once they solve it....

guys,

I contacted.. the support...

I solved that by....

We should not give thw like in the SQL rather we should give in the Transformer derivation for the refrence look up..

I.e.
when you do a look up on the string that you are going to match up for example

If you want to give in the like stament of sQL

LIKE '%?%'

I should be give in the Transformer Dervitaion part like this


'%':Regfrencestring:'%'

so you get what ever string from from the source that contains the string in reference...

thanks everybody for your support.Especially Ray...

Thanks,

g_rkrish wrote:

ray.wurlod wrote:Stop. Step back. Ignore DataStage for the moment. Write out (in English) a complete specification of what is supposed to happen, including one or two examples. Then post that here. ...

Ok here is what it is...

We have a tableA. where we have strings like 1000 10001 1004..

There is another tableb which has real data....

The question is is ..

We need to find ...
1.What are the string in Table B that starts with strings in table A
2.What are the strings in Table B that contains strings in table A
3.What are the strings in Table B that is equal strings to table A

Pls let me know if you need more explanation on the problem.....

Was your issue resolved?

I was thinking of counting the length of data in table 1 (len(var1) and using the length to cut first part of data from table 2 and then match them. Cant think why it will not work...

Krazykoolrohit wrote:

g_rkrish wrote:

ray.wurlod wrote:Stop. Step back. Ignore DataStage for the moment. Write out (in English) a complete specification of what is supposed to happen, including one or two examples. Then post that here. ...

Ok here is what it is...

We have a tableA. where we have strings like 1000 10001 1004..

There is another tableb which has real data....

The question is is ..

We need to find ...
1.What are the string in Table B that starts with strings in table A
2.What are the strings in Table B that contains strings in table A
3.What are the strings in Table B that is equal strings to table A

Pls let me know if you need more explanation on the problem.....

Was your issue resolved?

I was thinking of counting the length of data in table 1 (len(var1) and using the length to cut first part of data from table 2 and then match them. Cant think why it will not work...

I will not work..Beacuse your are matching the length rather than the string itself..suppose if i want to llok at start with 10 ..It may get the string start with 50 also..but i don't want that...