How to lode data in sequntional files perform faster?
what is diff b/w datastage 8.1,8.5,8.7?
Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD
how many types of remove the duplicate records?
How to reverse the string using SQL?
Explain the functionality of your current project?
1 Answers IBM, Miles Software,
How can you find out whether datastage process is running or not in unix?
How to clean the datastage repository?
In merge stage can we update the values?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
what is use of SDR function?
What are the different type of jobs in datastage?