in oracle target stage when we use load option and when we
use upsert option?
No Answer is Posted For this Question
Be the First to Post Answer
how can we join one oracle & flat files ?
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
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?
Triggers,VIEW,Procedures
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
Explain entity, attribute and relationship in datastage?
What's the Main Function of the Staging area in DWH
If the job aborted in a sequencer, how can we start that from the previews successful job.
what is flow of project?
I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.
which memory is used by lookup and join
Describe link sort?