DSXchange

I am using User Defined SQL in connector stage to Run my DDL Statements

Regards,
Sachin Gupta

Hi Team, My job flow is like below Seq File --->Transfomer---->Teradata Connector Stage I im passing two values from my file as '0' & '1',based on these values i want to execute DDL written in the teradata Connector stage. I am using constraint in transformer as if value equal to '0' than execut...

Hi Team, I am using teradata connector stage in my job.The column sequence in my user defined query in like ColumnA, ColumnB, ColumnC. But while defining the column sequence in column tab of connector stage the sequence in differ like columnB,columnC,ColumnA My job is running successfully,the data i...

Hi,

In my job i have created one sequencer,what i want is if i missed out to pass the value in sequencer parameter while running it,my sequencer should not run or it should abort.

Please help me on this.

Regards,
Sachin Gupta

Hi, I am trying to load data using teradata connector stage using a one to one view instead of table. I am using "Bulk" mode and Load as the operator. But the job is aborting with RDBMS error code 3853 which says that the table name used is a view. Can anyone give inputs on this issue Than...

Hi,
Thanks for your reply,

I want to capture the instance ID that datastage engine creates to run any datastage job such as PID number in Unix.

Regards,
Sachin Gupta

Hi,

I want to populate Job Session ID (Datastage tool session id for that job) in my Datastage Job.This session id value i have to pass a column value to my job which will further loaded to table.

Please provide me some solution on this.

Regards,
Sachin Gupta

Hi

Thanks for your reply,can you please brief me about how to use trigger expression to check parameters.

Regards,
Sachin Gupta

Hi, I have a sequencer and I am passing some parameter values manually to it. What i want is, if suppose i forgot to pass value to any one parameter, my sequencer should not run or if runs it should abort immediately or should prompt me for every parameter. Can we do this in sequencer without using ...

Hi, please make a single column using concatenate operator for all the composite key column,then use remove duplicate stage after sort. [quote="josh.guffey"]Hi Everyone, I have a small table with a 3 data element composite key. My requirement is to check for duplicates within this composit...

Hi,

Read ur file with a delimiter that u think will not come in ur file as a delimiter,this will read record in ur file as a single column.

If you want to create the different files of same delimiter we can do that also using a transformer and count function in the constraint.

Regards
Sachin Gupta

Hi, I am using one seq file linked to a transformer and then one output sequential file.I want to calculate number of records that are coming from my input seq file.I don't want to process the column that are coming from input seq file. Only record count should be remain in the output file. can we d...