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)
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
What are the partitioning techniques available in link
how to abort the job its matain duplicates?
I have 3 jobs A,B and C , which are dependent each other. I
want to run A & C jobs daily and B job run only on sunday.
how can we do it?
explain about citrix scheduling tool in datastage
hi iam new to this tooliam cmpltied to know abt datastage so
now iam in project tell me whole step by step what iam doing
iwnt to go with exp so plz hlp me pals
disign the complex job in u r project?(they are aksing only
complex job design and then data flow...)
if we using two sources having same meta data and how to
check the data in two sources
is same or not? and if the data is not same i want to abort
the job ?how we can do this?
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 ?
Hi,can any one please mention list of dimension and fact
tables for Sales and Distribution System for a
Is it possible to query a hash file?
1.new record it will insert but changes of natural key
is not present in taget i want
to update (here key is composite natural key )can any one
help this to explan how to do
how to find diff between 2 dates without using Icon...
There are two file are there .1st file contains 5 records and
2nd file contain 10 records in target they want 50 records.how
can achieve this
How you Implemented SCD Type 1 & Type 2 in your project?