DSXchange

Hi Raghav

Couple of questions.

1. How much changes will you expect a day?

1a. How frequent?

2. What will be the hit? (To query the data)?

3. Growing Datavolume / day?

4. which DB you are using?

DS User

These type of rejects may give warnings. In some projects they may not allow warnings.

Keep it in mind.


DS User

You can take more than one copy of the input data. shuffle the metadata order Rename the column Drop metadata etc. All depends what you need to do? where you need to use! Example Scenario: Input date will pass into AGGR stage, as well as to JOIN stage from a COPY stage and then do inner join to comb...

sorry craig

Hi I cant understand what you are tying to say. If you have the colum like Byte_Received/sec , then in ODBC stage you need to give the column name as BYTERECVD_SEC and make it as user defined query and there you can give it like select "Byte_Received/sec " as BYTERECVD_SEC from table name;...

As far as i know, you wont find much difference in result, depend the data volume.

Hence you are writing it in a file, i guess you wont find much.

In the coming days, if you want to do something in the data, that time TFM will help.

DS User

Hi Friend

select "Byte_Received/sec " as BYTERECVD_SEC from table name;

use BYTERECVD_SEC as a colum name in your metadata.

DS will not accept special char.

DS User

You should read the doc and understand where to use which partition!

Guess: You are going to check this value which is one of the col in the file.

Seq File > TFM

Write a routine and use that routine in TFM and pass that col as a param and find the result. So that it can be used as a param.

DS User

Go to Director > Job > Cleanup Resources. Now the new window will be ready for you. Look into the bottom Locks and choose show all. Find your job will be waiting for you. Notedown the PID. Then choose show all radio button in Process. There you can find the same PID. Select it and Logout. OR ps -ef ...

Hello All Just a common question relates to SCD Type 2. To find and implement (SCD type 2) we are using different stages like Change Capture, CDC, JOIN etc. Question: If the source provided a record (delta) means, there is some changes in the existing record. In that case why should not we close the...

You are right Ray.

What the solution was found is temp fix.

There is no direct way to do it. Still you can do it.

Need to make one identy col as a key to join two links. Use join stage (full outer for safer) and the in the TFM combined the col.

What is your source?

DSX is not fast food shop

fine, let me know your source?

DS User