DSXchange

Examples are always seems to be simple.


A
__

1
2
5
6
B
__

3
4
7

what should be the ouput in C?

1. Change the date format.
2. In the TFM you can use to stage var to find the count by using your own logic.

Hope this link might help you.

viewtopic.php?p=381676

Right now i am sitting in Win system. I tried using char and it is working in win. I trust it should not be the problem if it is , CHAR /VC data type.

Go to unix box and open the file and see.

DS USer

select max(RUN_ID) as RUN_ID from schema.Table_Name

Hi Sometime this will be tricky. Try like below will help you. Step 1. Do you applied any sort / partitions?. If so apply it in both links. Step 2. After the first run, use the key col alone. If you have more than 1 key col, add one by one. These type of appraoch will help you to figureout the issue...

Hi,

Where are you storing your output?

What is the Data type?

DS User

INT Data type will treat it as 0.

What you will get, if you read the Binary file using Seq file stage?

Hi

In the Datastage double click the specific colum; there you can find a check box for microsec. Pls select it - you can get those.

Cheers
DS User

Why not simply a Lookup stage followed by a Transfomer stage to convert null to "N" and anything else to "Y"? Sorry Ray I didnt explained properly. It is not just to convert "Y" to "N". I need to close the present record date - 1 as the close date to the prev...

ray.wurlod wrote:Why not use SCD stage?

I cant at this moment. Due the C++ version mismatch with 8.1 SCD is not working. So i have no other choice. Shall i use the Server HASH LOOKUP to do this?

Guide me.

Thanks
DS User

Hello All I have a scenario for SCD Type 2 and i need to know the best way to handle it. Trying with Change Capture Stage. Source Data (SQL Server) 1,ABC 1,CDE LKUP DATA (SQL Server) 1,XYZ Expected Output: ID DESC STAT 1 XYZ N 1 ABC N 1 CDE Y Regards DS User

If i am right, look into system variables. it will help you.

Nagac wrote:Hi All

I have a job like below

Dataset---->Transformer---->DB2

When i run the job it's got aborted after 500 rows .(total rows were 2000)

Is it possible to start from 501 row??

What error captured in director?