DSXchange

1)I have read the link mentioned in above post but nowhere it is mentioned how to see those characters because in my project they are using Ereplace function to replace @FM with '' in some places not in all places.Without seeing those characters It is difficult to guess when to use Ereplace function?

In the execute command activity I have seen following trigger condition. Ereplace(Cmd_CheckRejectSize.$CommandOutput,@FM,'')>0 I want to see the @FM characters using Unix or Note pad++ or any method.Please let me know how to see those characters.I have idea about @FM characters but not sure how to s...

In my previous project when i select show performance statistics datastage will show noof records processed between stages,some colurs like green etc) when i ran any Job by using designer. Recently i was changed to some other project not able to see any anything even though i selected this option. C...

I have userdefined sql In netezza connector which will return 100 rows.Let us assume I Included following condition in where clause WHERE mod(datasliceid,[[node-count]])=[[node-number]] 1)Can anyone explain for each row what is the value of [[node-count]],[[node-number]] and datasliceid.I am using 4...

1)My doubt is how [[table]] and [[twt]] will be selected.I have not define anyvalue for [[twt]] and [[table]].

2)What is the advantage of TWT in netezza which is not present in oracle database?

INSERT INTO [[table]]
(col1,
col2,
col3)
SELECT
col1,
col2,
col3
FROM DB1..[[twt]]


I am not able to understand above query in netezza connector.sql query is mentioned in user_definedsql.Properties are mentioned for
TWT connection also.


Could anybody explain above query how it will work?

When i had discussion with my team mate he told look up stage should be used when the reference data is small.Not sure what could be the reason and even he do not know.Any thoughts on this

Any input on the above post.input is really appreciated

encode and compress stage understanding I already read following link and just want to know mu understanding is correct or not? http://www.dsxchange.com/viewtopic.php?p=363987 1)compress stage is used to compress the data and it won not support encryption 2)Encode stage is used to encrypt the data a...

what is the need for recreating your data model on data architect?

is there any other option other than UNIX ODBC drivers for Excel since unix admin does not know about this?

i checked in google and red books to get information about repartiting in datastage but no information.I heard about partition and collecting algorithim.what is repartiting in datastage
and when it is required.I came to know this term when i had discussion with my team mate?

I need to convert .txt file to excel file (with extension .xls). Currently I am converting .txt to .csv by replacing the delimiter with |, which is opening properly in Microsoft excel but i need to convert into .xls. Any input is really appreciated. Of course in 9.1 we have separate stage for it but...

1)Use MEtadataworkbench tool or 2)Go to Stage Types->server->select Find where used all types for Hashed File which will not give exact solution for but it will help you. or 3)In one of the post i read we can use ds_jobs or other hashed files but not sure exactly how to join to answer your question

I think you have have to move dsparam file to the new project and if you already done are u able to see proper values in unix?