DSXchange

Hi All, Could some please explain me what does " DSU.CommonInitKeys " in the following command do DSU.CommonInitKeys(workdir:" ":oradb:" ":orauser:" ":orapwd:" ":SeqIdName, returncode) is it a user defined Routine , where can i find the details about...

That is what iam not able to understand too .

the following are in the columns field

ag_id, duns_nbr .

Hi Ketfos , Yes the order of the columns i as i have mentioned the post . but even when the order is same as in sql still iam getting the error for other oraoci8 stage which is also used as lookup here is the following error for other table TAMContactsPostAvatar..named_account_info: ORA-00904: "...

Hi all, When i try to view data from a ORAOCI8 stage (used as lookup ) iam not view data and iam getting the following error, TAMContactsPostAvatar..duns_company_lk: ORA-00904: "DMETRO"."DUNS_COMPANY_LK"."DUNS_NBR": invalid identifier TAMContactsPostAvatar..duns_company...

Adding to point to the previous post ,


can i have different metadata in each file it is writing but to one sequential stage.

Thank you all again,

Thanks Arnd for your answer,

But what is the advantage of having single sequential stage but writing to different files for each link , over writing to different files with multiple sequential stages.

Thank you all for your time and help,

Hi All,


Can i have a sequential stage with multiple input links ?

Can are OCI stage have multiple input links to the same table with different update options for each link .

Please clarify me,

Thank you all,

Thank you so much Kenneth Bland.

so even if the date comes as 5/8/2005 (mm/dd/yyyy) instead
of 05/08/yyyy still can i use "iconv" function.

Please confirm me.


Thank you,

Yes all the input links have the same metadata , so in that case can i use

link collector to combine the outputs .

Thank you,
Purna.

Hi all,

Can i use Link collector alone to to combine the two files (concatenate)

or should link collector and link partitioner go together.

Thank you all,

Thank you so much for your suggestions Kenneth Bland.

Hi all, how to implement outer join with datastage , i have two files f1 and f2 f1 is the current file and f2 is the old file , f2 is a dump from the table , iam comparing those two files to get records , that are 1. records are in f1 but not in f2 (new records) 2. changed records 3. records that ar...

Hi All,

can i use i Iconv for the following dates

format is mm/dd/yyyy and if the date comes as 5/8/2005.

Thank you all for help,

Hi All,

Thank you very much Ray and Chulet for your answers,



But how implement second option Ray, would please suggest me.


[/quote]Create your hashed file with more than one key column, and perform multiple lookups.

Thank you all lot