Interested to Buy Any Domain ? << Click Here >> for more details...
j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?
1 68548000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
2213How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
26151) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
7 199271)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 ?
2024Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
3 12581Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
HCL,
1 4856A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
TCS,
1 8328I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?
TCS,
1 6587Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
3 13801
If you want to use a same piece of code in different jobs, how will you achieve this?
What is the difference between validated and compiled in the datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
How do you schedule or monitoring the job?
Define Job control?
How can you write parallel routines in datastage PX?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
How do you import and export the datastage jobs?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Explain usage analysis in datastage?
What are the processing stages?
What are the features of datastage flow designer?
What are the various kinds of the hash file?
Can you implement SCD2 using join, transformer and funnel stage?
Can you filter data in hashed file?
