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)
Sorce contins the metadata
hyderabad,chennai,banglore by using nested loop sequence
select sourch as hyderabad in target just run target as
hyderabad only not others please give me answer thanks in
advance(give reply how to wrote logic using nested loop
explain about citrix scheduling tool in datastage
Please design a job for dis requirement with
my source table like dis.
To loaded to target like dis
my requirement is
every employer have three qualifications i.e a,b and c.
what qualification missed in source table that will be move
to target systems.
Hope u got it the requirement. Right
how to create document in datastage?
Can we use target hash file as a lookup ?
how many rows sorted in sort stage by default in server jobs
What is process model?
how to read 100 records at a time in source
a) hw is it fr metadata Same and
b) if metadata is nt same?
Which warehouse using in your datawarehouse
Hi,can any one please mention list of dimension and fact
tables for Sales and Distribution System for a
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)
how to find diff between 2 dates without using Icon...
What is developer responsibilities in UAT
(user acceptance testing and
Post implementation phase?
What is Ad-Hoc access? What is the difference between Managed
Query and Ad-Hoc
How 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?