i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE
7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD
MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD
MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME
HOW CAN I DO THAT.
THANKS
No Answer is Posted For this Question
Be the First to Post Answer
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
why do we need a datawarehouse when we have databases to store data?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
In one project how many shared containers are created?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
how to handle null values using transformer stage?
Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C
8000 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?
How do you start developing a datastage project?
what is 'reconsideration error' and how can i respond to this error and how to debug this
State the difference between an operational datastage and a data warehouse?