DSXchange

Hi, I have two records in the input, while processing I split the first record into two. But in the output Im getting only 2 records which is the 1st record and the splitted record.Im not getting the 2nd record. Is the input and output count should be same? Is there any possibility of getting all th...

Search for DaysFromDateSince. And then decide what "5 months and 2 weeks" means - 154 days? And is it a date or a timestamp? ... Hi, It's a Timestamp field. Will it work for Timestamp also. Let me try this option and also pls let me know if any other method is there for Timestamp. Thanks.

Search for DaysFromDateSince. And then decide what "5 months and 2 weeks" means - 154 days? And is it a date or a timestamp? ... Hi, It's a Timestamp field. Will it work for Timestamp also. Let me try this option and also pls let me know if any other method is there for Timestamp. Thanks.

Hi friends,

I want to add "5months and two weeks" in a date column(Timestamp).
What is the function i need to use. Can anybody help me on this.
Thanks.

Of course, if I remove the conflict columns from the source (although, I repeat, I "discard" them in the first transformer), the problem dissapears, but I would like to know why this is happening, when RCP is disabled for the project Thanks again Hi, What is RCP and from where we need to ...

jpram wrote:Check the options you have used like,Explicit Key all columns,etc....
If you have key columns specified seperately

Hi,

Thanks for ur reply. I have used the option "Explicit Keys & All values".
I got the solution, the problem is in the source extract.
Thanks.

Hi Friends, Iam using a ChangeCapture stage, volume is 40k. For manual verification, i have modified one new insert record and one update record, when i tried using a Dataset after changecapture stage iam getting the changecode as "2" for both Insert n Update. My Understanding is, ChangeCo...

Hi,

Iam getting a warning in Lookup stage like,

"Lookup: Ignoring duplicate entry at table record 9; no further warnings will be issued for this table"


Iam trying to get n links from same copy stage and hence ends up with this warning.
Any solution for removing this warnings.


Thanks.

Hi, I need a Quick turn around from u guys.. My Issue is like, Iam using a Join stage (Left Outer), Iam just capturing the matching records into the dataset. Iam getting the required amount columns exactly. But, i need to check for nullability for these amount columns, so i have used transformr afte...

chulett wrote:Not sure how anyone can help without knowing what "aborts" you are getting. Please post the actual error message(s) from the job's log. ...

Hi,

Excuse for not mentioning th eabort msg, It says "Deadlock Time out error"

Hi, Iam using Loading Job, which the update option as clear the table, then insert rows, with execution mode as 'Parallel' and it's two node config. Array and trans size is 500. If i run this Job, iam not getting any error or abort msgs, but is i run the same Job again it's getting aborted. This is ...

keshav0307 wrote:if hash partition on join keys not working then something unusual happening there.
do you have any char or varchar column in join keys?

HI,

The Join column is Varchar column and i have handled TRIM and NULL function in extract query itself and also in the Intermediate Transformers..

Looks like a partition problem to me. What partition have you used? Use hash partition on key fields on both links to the join. Hi, NIce to get a reply from you.. Thanks.. ya its partition problem only, i have tried using Hash partition then iam getting 2records out of the 3matching records... Any ...

Looks like a partition problem to me. What partition have you used? Use hash partition on key fields on both links to the join. Hi, NIce to get a reply from you.. Thanks.. ya its partition problem only, i have tried using Hash partition then iam getting 2records out of the 3matching records... Any ...

Hi, Iam just Joining two Datasets with single Key column using JOIN stage. The Data has been verified for NULL, TRIM etc. The output of Join is giving 0 records but iam having 3matching records. Iam getting the same three matching records in Backend Query, while using Lookup stage but whats the prob...