DSXchange

Hi, I need to delete or update a record from DB2 table. My job design is like this. DB2 API stage--------->Transformer-------->DB2 API Stage (To read the table) (To assign a value (To update or Delete) Into stage variable) Qurey(in Second API Stage): 'DELETE FROM raoridbf.model WHERE (raoridbf.model...

Here is one more line to my issue.

"My Underlying database is DB2 in AS/400 environment."

Regards,
iamnagus

I am using DB2 database and DB2 stage very first time in this project. I am trying in all the possible ways. Even issue also not so self explanatory. shoud i need to specify any thing in the following files? if so, what & how? .odbc.ini file under <Datastage Home Dir>/dsengine - ucodbc.config fi...

Hello, I need help on DB2 client connectivity from Datastage. I am using DB2_UDB_API_0 stage to pull the data from a DB2 table. I have DB2 client on my local system. I am able to access DB2 through Command Window. But from my local machine i could not. Even some jobs(with the same stage designed at ...

sateeshbabu, This is not that much easy to compare the two applications(Tools) unless one should have vast real experience on the different tools. According to me, Datastage is a bit better than Informatica on the aspects the way they provides features, functionality, debugging, performance. But bot...

I going to work on the specified requirement. This is new requriment to me. I just want to know the procedure about this in advance. Can any one guide me please?

Thanks & Regards,

This topic already discussed in the earlier days.

Refer this topic:
viewtopic.php?t=102403&highlight=scd

Regards,
iamnagus.

Hi, Using two Dates fields also we can implement the Type2 SCD. This is one of the way where you can implement Type2 SCD. But it is bit difficult to explain in brief here how exactly achieve it in the job. With the combination of a Primary Key & Effective-In-Date key(composite key) you can show ...

[I doubt that this will work; the [ ] indicate a substring operation, but the data type is date, not string]

Ray,

You are right. while giving the answer, i had not put data types in mind.

Regards,
iamnagus[/quote]

[Selecting Datastage is good decision. But dont be specific on any tool. They come and go. Try to be experitised on different domains. If you are master in the doamains then you can play with any tool.] I mean, Suppose take retailr business(I say this is one Doamin). One should have detailed knowled...

Yes you can't use modify stage to do arithmetic operations.

As for me,
Modify stage can be used to change the data types,sizes and to handle nulls i.e to defaults to nullable fields. Use trasnformer stage for your requirement.

If any nullable field being used in the Transformer, need to handle that field. In this scenario use NullToZero() function for the field 'pt_state" then make Nullable 'NO'. It works for you. Check.

Selecting Datastage is good decision. But dont be specific on any tool. They come and go. Try to be experitised on different domains. If you are master in the doamains then you can play with any tool.

The default values(In Change Capture Stage) for Update:3 Insert:1 Delete: 2 Copy : 0 But you can Alter/Override these values if want. You can find these settings in Chage Capture under the tab properties/Options.

From the lookup reference, Apply like this:
Link_Name.Date[1,8] and do the lookup with source.