What is the sortmerge collector?
Differentiate between hash file and sequential file?
What are the different common services in datastage?
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know
how to cleansing data
how to identifie,is it innerjoin,leftouter join in lookup?
How we can covert server job to a parallel job?
I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3
What are the different database update actions available?
What are the different options associated with dsjob command?
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
What are orabulk and bcp stages?
What is the default padding character?