Input file one has data as shown below
Input file two has data like
Design a data stage job which will provide me three output files as shown below:
Let me know your answers
Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.
eno ename count
1 qaz,wsx,edc 3
2 zxc,asd 2
3 qwe,wer,tru 3
4 rgj 1
I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
This is UNIX question asked in DataStage Interview.
Say I have n numbers of records in a text file.
I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file.
(Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
what is the custome stage in datastage? how can we impliment that one? plz tell me
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What are the partitioning techniques available in link
1)s.key generate 1 to 700 records today. tomorrow another
400 will updated how to update the records using s.key
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 the Environment Variable need to Set to TRIM in
Project Level?(In transfermer, we TRIM function but I need
to impliment this project level using Environment variable)
what is the use of skid in reporting?
How to lode data in sequntional files perform faster?
Explain the situation where you have applied SCD in your
What is process model?
i have a job with 3 possibiliies
finish with ststus ok
how do you handle these 3 in job sequence?
explain the situation where you have appiled scd in your project? chandu