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)
8000 jobs r there i given commit, suddenly job will abort?
2)diff b/t transformer stage & filter stage?
3)how to load the data in the source?
Can we use target hash file as a lookup ?
Hi,can any one please mention list of dimension and fact
tables for Sales and Distribution System for a
what is the custome stage in datastage? how can we impliment that one? plz tell me
how to read 100 records at a time in source
a) hw is it fr metadata Same and
b) if metadata is nt same?
1)what is the size of Fact table and dimension table?
2)how to find the size of Fact table and dimension table?
3)how to implement the surrogate key in transform stage?
4)write the configuration file path?
5)how many types of datasets explain?
6)diff b/w developed projects and migration projects?
7)how to delete the header and footer file of the sequencer
8)how can u call the parameters in DS in unix environment?
9) how much data ur getting daily ?
Which is the best institute in Hyderabad to learn OBIEE and
DataStage?Please tell me faculty name also
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 ?
How to find value from a column in a dataset?
what is the use of skid in reporting?
how many rows sorted in sort stage by default in server jobs
Converting Vertical PIVOTing without using PIVOT stage in DataStage.
DEPT_NO EMP1 EMP2 EMP3
10 subhash suresh sravs
2) How to implement Horizontal PIVOTing without using PIVOT stage.
Hi , Can anyone give few examples of scenarios and there
corresponding design in datastage..i am new to this
tool...confused in design while my manager asking to design
Please post the URL if there..so i can go through it..
Thanks in advance...
im new to this tool im now at project plz tell me step by step
process how to design plz help me i wnt to go with exp for job
plz give me d proper design and explination