DSXchange

I have requirement to Join tables - multiple SQL Server tables with joins to ONE Oracle table with LIKE condition in ODBC Plug-in. I tried giving Oracle DB name in query and getting Invalid object name error. Query in ODBC SQLServer connection - select Asset, Tag from asset join SQLSERVER .Portfolio...

I do not know why there is so much confusion on these Topic. I am trying to build source SQL that changes from run to run. It was suggested to build externally as parameter or Kim suggested. My first question is what values should i declared in parameters. Will below will be sequence of steps to res...

I needing to pull information from a table using SQL in which uses field variable from "if-then-else" derivation. Using the % wildcards in If-then-else. SELECT A From B where A LIKE 'VARIABLE' VARIABLE= If LOCATION LIKE 'Technology Center' Then 'BACKUP ' Else 'TTCE' else If LOCATION LIKE ....

Let me explain to you in brief.... Need to CALL SELECT ...LIKE VARIABLE IN Transformer/Applicable Stage.I declared VARIABLE as STAGE VARIABLE. Value of VARIABLE = If LOCATION LIKE 'Technology Center' Then 'BACKUP ' Else 'TTCE' else If LOCATION LIKE ......... I am using '%Technology Center%' to check...

Hi

Sorry about mis-pronouncation.
Can it be done by Sub-routines like DSRoutines.
I am not particular that it should be done in Transformer stage.
Any type of solution for this issue will be appreciated.

Sarathi

LOC = 'SELECT searchcode from LOCATIONS WHERE searchcode like ' : STAGEVARIABLE

This is not working. It's taking as string and passing...

Craig- Do u have solution for this. I appreciate your help


Sarathi

Yes LOC is target field

Can we pass StageVariable into Select statement in Transformer Stage..

Here is what i am looking to pass to LOC VARIABLE

LOC = SELECT searchcode from LOCATIONS
WHERE searchcode like STAGEVARIABLE

Any help appreciated

Sarathi

Below is method i followed and did not work. Am i making any mistakes here ? 1- Sorted data on Key and Status 2- In the transformer created separate two types of records using constraint 1) Status = Removed 2) Status = Implemented 3 - Duplicate state and pulled only Last record 4. Created STAGE VARI...

Thanks for reply. I have only one query which pulls data and you mentioned to go for lookup below. Does it mean LOOKUP Stage ? As i don't have Two Sources prefer Transformer Stage. - If Rem_status='Removed' and rem_status=imp_status Then Pass this record to seq stage else Reject record. Let me know ...

Do anyone had task to do this type of Logic and found solution for same.

I am having DTS issue where i need to Route one of Duplicate value to different file and then remove duplicates. Here is an examples of how data looks for columns Code & Status Case 1 Code Status 1DKSSK2 Removed 1DKSSK2 Removed 1DKSSK2 Removed Case 2 Code Status 1DKSSK1 Implemented 1DKSSK1 Remov...

If Link.Field[1,4] = 'DELL' then 'DELL' else is working.

I tried Matches 'DELL' with 'If then else' condition and it was not working.
My assumption is we need to use substring[] for IF THEN ELSE

Thanks for all

Sarathi

Thanks for comments. My task is NOT to check exact string but should work as Oracle like command - Like 'DELL%. Tried to use Index send by Kunnal but not parsing. Craig If Link.Field[1,4] condition is working but what if we have values 'DELL12' or 'Cisco32' if index("DELL", LkFrom_CMDB_Tab...

GSSR - I'm little confused as what you are saying below - Use Copy stage , Instead of writing the CSV file directly and get anither link from copy stage to Join. Now you can edit the Metadata in the links Should i use TWO Copy stages for each CSV File and then Join them. And then output of Join goes...