DSXchange

Hi Friends Below warning is giving problem to my job can any one give suggestion """APT_CombinedOperatorController(0),0: Field 'MBPUIT' from input dataset '0' is NULL. Record dropped."" but this field have data and lookup field also have data I given this condition in Trans...

Hi Friends
Below warning is giving problem to my job can any one give suggestion

"""APT_CombinedOperatorController(0),0: Field 'MBPUIT' from input dataset '0' is NULL. Record dropped.""


but this field have data and lookup field also have data

Hi Friends, Can any one tell how to sove below warning APT_CombinedOperatorController,0: Invalid character(s) ([xDB]) found converting string (code point(s): PK[x03][x04][x14][x00][x00][x00][x08][x00][xDB]t[x90]:[xFD]*[x11][xAB];[x07][x00][x00][xE6][xD5][x00][x00]=[x00][x00][x00]OUT_DR0_0007_MCO_Mat...

Your metadata is incorrect and it's saying it can't find the record delimiter you said would be there. As noted, correct that. ... I have created the file in the previous job without using any record delimiter. I am running the jobs on windows 2003 server. The said job was running fine previously. ...

deesh wrote:Hi Friends,

When I am look uping data, look up is not working, data is coming as null but data is there, Moreover job is not showing any warning and failures.

I am prepared same condition for two jobs but one job is working, second one is not working i given same conditions but not working.

Hi Friends,

I am phasing below failure.

SEQ_SAP_FILE,0: Consumed more than 100000 bytes looking for record delimiter; aborting

Hi Friends Can Help to me How to implement below logic. I Taken Lookup and given reference key L _ID=LSN It will generate values If it is not have value how to implement 'kkkk' Value in transformer, I am confused in this. Logic ""To convert O_ID zone, read the conversion table with key L_I...

deesh wrote:Hi Friends,

When I am look uping data, look up is not working, data is coming as null but data is there, Moreover job is not showing any warning and failures.

---Its Varchar

Hi Friends, When I am look uping data, look up is not working, data is coming as null but data is there, Moreover job is not showing any warning and failures. """ I given Continue option""" In the same lookup I given two reference keys from two tables Table1 Table2 1. ...

Hi Friends,

When I am look uping data, look up is not working, data is coming as null but data is there, Moreover job is not showing any warning and failures.

Hi Friends,
I am encountering the Lookup warning can tell to me the solvation This data coming from SQL Server


Lookup_140,0:Ignoring duplicate entry at table record 3; no further warnings will be issued for this table

Hi Friends, When I am sending data to Rejects file it showing below warning can tell to me how solve this warning. This "LOSGR" Having Decimal Datatype, Size is 13,3. REJECTS: When checking operator: When validating export schema: At field "LOSGR": "null_field" length (...

Hi,
one of my coleague accessed my job for reference suddenly datastage has shutdown, when I reopen It showing MR.'X'has accessed the job, but actually he is also unable to access the job how to access my job. Please help to me.

HI FRIENDS, I am generating report with datastage, In Aggregator I given One group only, but instead of one row it generating two rows. Example: I Given "Job Name ", "START_TIME", Its generating each one two times instead of one time TR--AGG--JN---TR--ODBC........ This is the flo...

SAP Table having only 98 rows but Another table have more than 20000 rows how to use unique key for this.