In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
Answer / sreenath
I'm not sure .......
In Oracle database target stage u have a options insert/upsert option u can put that option everything false into place
Is This Answer Correct ? | 0 Yes | 0 No |
Explain the situation where you have applied SCD in your project?
specify data stage strength?
I am getting input value like X = Iconv(ā31 DEC 1967ā,āDā)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().
i want job aborted after some records are loaded into output by using only sequential stage and dataset
WHAT IS FORCE COMPILE?
What can we do with datastage director?
source contains 2 columns comes to target 4 columns how
Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?
In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario
What is Fastly Changing Dimension?
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?
What is the default padding character?