DSXchange

Source1-- table1
source2--table2

Table1 and table2 does not have any key column or say joining column.
How to get the data from these two different table into one table.

any

hi, source wiil be like this: co1,col2,col3 100,a,hyd 101,b,hyd 102,c,blore if i use remove duplicate o/p will be like this:100,a,hyd 102,c,blore but required o/p will be like this:102,c,blore can any one help....... use col3 as key column (depends on your process requirement) then u will get the g...

ray.wurlod wrote:Welcome aboard.

What's different about the system, and other systems, during the slow times? "Nothing" clearly is not the correct answer.

what are the operations are u doing in jobs... please explain bit.. so we can find the solutions

hi, recntly i got the job in DataStage, i know some documentation nemes like 1.mapping doc, 2.Technical doc,3.test csae doc,4.functional doc i know abe all above doc Except functional doc can any one give me brier introduction about functional doc fuctional document is one which contains the high l...

problem is with table ,,, remove the deadlock of the table and try to run ..
also check with update query..

you can use the sp stage for the same and capture the output of the sp into sequential file.

In transformation before genarating xml in constraints write @OUTROWNUM=1 AND @PARTITIONNUM=0.
May be this wil helpful.try it.

Thanks,
Mayura

Hi, the Source data as follows: Col1 Col2 1 aa 2 gg 1 aa 2 gg Required output: Col1 Col2 1 aa 2 gg need to identify the duplicate record existance. based on the first row if any duplicates occurs the error message needs to send into error table, if the duplicate does not exist the record will load ...

The row count on the link shows how many rows were sent to the database server, not necessarily how many rows were loaded. Are there any errors/warnings reported? Show us exactly what you're doi ... warnings comes as literal string does not match with format specified and link shows around 40k reco...

condition table contain data Target want to insert the records(may be old or new) and update all the records present in target. solution: currently i am using the DRS stage here in before query i used update statement means before inserting into table it will update the all data in table with indica...

source -- input file

lookup-- to dataset

after job run not getting populate to target and giving error as
Field <column name>from input dataset '0' is NULL. Record dropped.

Please solve.

vkhandel wrote:u can remove the tabs using "TR" command.

tr -d '\t' < {input file name} > {outut file name}

hey thx

i have removed the tab by using tr command and redirect it into one file and then i have removed the blank lines and spaces and redirect it into original file..

Unix file having spaces,blank lines and tabs
I am able to remove the spaces and blank lines but tabs are not removing from txt file.

Please help me out to remove the tabs coming in source file.

dspxlearn wrote:Mayura,

Check if the number of input columns and the field names in the source file/db is matching with the number of fields defined in your datastage job.

hey issue got resolve as mapping between two columns some how mismatch

Getting error while running the job as could not find the input filed for <column>.