DSXchange

It wont be static. Thats why we take previous day's records(end_dt = sysdate - 1). And source is a date. Any other logic other than doing lookup with the file containing incremental_date and routine logic. Regarding parameter file logic. In unix, i can copy text file content to parameter file like ...

Please advise.

Thanks

For varchar null handling can i give NullToZero in transformer. Will it take implicitly zero as string or i have to give NullToValue(column,'0').

Thanks in advance.

Sura, I understand all these logics. I just have a job with source ---> filter ---> copy ---> transformer ---> target. please understand clearly. I have given auto here in one run for all the stages. Another run, i have given as round - robin at the first partition setting and "same" in th...

Hi , My question is direct. If i set "auto" my job will choose round robin first and then the same partitioning as the stages are like tat. I am not talking about big performance difference. If i set the specific partitioning methods, will it escape the check by parallel engine "to se...

Hi all, I have one job, which will run in auto partition and i dont have any stages which will choose hash partitioning or db2 partitioning. Is it good to choose auto or "round robin for the first stage and same for the rest of the stages. Because here by specifying round robin and same am mini...

Hi all, Present logic : Source : Sql server Source has date column through which incremental extraction happens. First time start_dt = 1-1-1900 and end_dt = sysdate -1. Next time end_dt + 1 will become start_date and sysdate - 1 will be end_dt. This s just to ensure that no record of today should be...

I changed the write method to upsert and then could see the output reject option. I set it to true and was able to capture the records in reject file. But if the write method is changed to upsert then how will the dupes be captured? Can someone please throw some light on this. I can capture dupes ea...

Hello, My job requirement is to insert data in Oracle database. In case any of the records is rejected, it should be captured in the reject file/table, irrespective of the reason, along with the Oracle Error Code and Message. I was trying to use Oracle Enterprise Stage, but it I attach a reject link...

Hi all, Source --> shared container ---> copy --> target Source : 20 columns Shared container input stage obviously has 20 columns. Inside shared container, first stage is column generator after input container. input tab is empty in column generator. In output tab, a created one dummy column. i ena...

you mean size 20 with varchar datatype or something as varchar(20)?

Nice quote, Ray. :wink: Hi chulett,ray Stop insulting others by giving quotes and encouraging it. I asked in the right sense and just because you are moderators,you should not write whatever you want. In many posts u guys do this only. If you consider some questions as silly, dont reply rather than...

I enabled RCP for shared container alone inside the job properties.. Its working fine..

Thanks

Compilation error message : Link meta data must be consistent in order to use Shared Container 'temp' Link types must match. Names of columns on the container stage link must be identical to, or a subset of, those on the mapped link. I enabled RCP also. INPUT : validation successful ( link1 has 20 c...

In link1 i have 20 columns,but the validation is successful. But why not for link4. i mapped link3 with link4. when i have same metadata the validation is successful, if i keep 20 columns from link1,its says link4's metadata is not superset or same of link3. Then why its successful for the input val...