DSXchange

Thanks Ray for the reply.

Is there any possibilities by using virtual table or reference table or by using data rules within IA?

Members please feel free to put any suggestions or comments.

[quote="ETLJOB"]After your database read have a transformer and by using stage variables setup a flagvariable (Y or N) Then check 1. If col1=col2=col3 the set flag as 'N' 2. If col1=col2 or col2=col3 or col3=col1 set flag as 'N' Then, have a constraint to output the required records based ...

I have a requirement to profile 3 columns of 3 different tables (which has a common key) and capture a result where either 3 of them are not equal or at least two of them are not equal.
I would really appreciate any thought or help.
Thanks in advance.

Once you changed the code at SC save it and compile the job which is using this SC.

1. Define your all parameter like servername, schema, uid, pwd etc at user defined enviroment variable. 2. Keep all these parameter in one parameter set like $DB_USER, $DB_SERVER etc. and save. It will be saved at Repository. 3. Open Parameter set\Parameter and double click on Default Value. 4. Smal...

1. Define your all parameter like servername, schema, uid, pwd etc at user defined enviroment variable. 2. Keep all these parameter in one parameter set like $DB_USER, $DB_SERVER etc. and save. It will be saved at Repository. 3. Open Parameter set\Parameter and double click on Default Value. 4. Smal...

1. Define your all parameter like servername, schema, uid, pwd etc at user defined enviroment variable. 2. Keep all these parameter in one parameter set like $DB_USER, $DB_SERVER etc. and save. It will be saved at Repository. 3. Open Parameter set\Parameter and double click on Default Value. 4. Smal...

Exec_Command_Stage-------------->Job_Activity

At ExecCommand\Command pass following unix command:

gzip -d /path_of_zipped_file/zipped_file_name

We did:

Row_Gen-------->Store_Procedure------->Col_Gen--------->Output

First of all you have only 6 columns.
Secondly you don't have DYP at col4 in your sample data.

Based on your information, you could use file, lookup and funnel combination to solve this problem.

[quote="DSguru2B"]There is a huge difference between a number that starts with 12 and a number that starts with 99. See how much is 2^63. I bet its what you are getting. ...[/quote] Thanks. I changed SQL type from BigInt to Varchar and I'm getting the required result. Thanks again for your...

[quote="DSguru2B"]I doubt big int can hold that number. Its way above its limit. Check what the upper integer limit is for BigInt.[/quote]

But it works with
00012109614152087431682301311722200502
00012109614155689601682301311722200502
as an input

[quote="DSguru2B"]What is your target datatype set as?[/quote]

Source is flat file with NVarChar, length=38 and target Netezza with SQL type =BigInt and length=19

When I apply Left(DSLink2.src_surrogate_comp,19) to 00012109614152087431682301311722200502 00012109614155689601682301311722200502 it gives 1210961415208743 1210961415568960 which is expected. But when i apply for 99999999999999999999999999999999900001 99999999999999999999999999999999900002 it gives ...

you can also use topas, prstat -t, top etc.............or DSDirLog\rt click\monitor\rt click (at small screen)\show % CP