DSXchange

Hi, I am getting following error when i am running my Job. I am getting the error when i am using the Remove duplicate and surrogate stages for my job. SubArgs={asc}}}(0)0,0;Failure during execution of operator logic. SubArgs={asc}}}(0)0,0;Fatal Error:Need to be able to open at least 16 files; pleas...

Hi,

IBM will give the complete suite(IA and Business glossary)

How can i read data without header and trailer through sequential file?

I need row count for particular link, for that i am using DSLinkinfo Function.Can any body send the exact syntax for the DSLinkinfo.Is there any way to get the row count for particular link?

HI,

What is the syntax for convert NULL field to NOT NULL Field in Modify Stage?

T I tried using remove duplicate and Join stage and i am getting the desired output..... I treid aggregator as well. . U need the max ID records rt? In this senario how can remove duplicate will work.When u will use Remove duplicate automatically it will remove the duplicate records like 11,A,B,C 1...

what is the advantages by using the sort stage instated of in built sort?

reddysrc wrote:Apply this logic in constraints tab

Condition Not Met : Fail
Lookup Failure : Continue

then you will get the Leftouter join results .

thx
Rama

If we set the Condition Not Met=FAIL, job will fail.I guess we need to give the Condition Not Met=DROP.Correct me if i am wrong

How can i achive the Left outer join by using the Look-up stage?

i have 30 jobs, for all the jobs i need to pass 100 parameters to all the jobs.
This all parameters are in one table, so how ccan i call the table to all the jobs. I need this at job level ,not sequence level.

I have parameters in a table. how can i link the parameters table to the job?

What is the exact difference between the sparse lookup and normal lookup?
i need clear information, i know if data is comming from souce is small we will go through sparse lookup.
can you please give me the more clarification about this?