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

Post New Answer

More Data Stage Interview Questions

IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,


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?

11 Answers   CTS,


why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

0 Answers   IBM,


In one project how many shared containers are created?

3 Answers   NTT Data,






1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

0 Answers   IBM,


how to handle null values using transformer stage?

1 Answers  


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

3 Answers   Deloitte, IBM,


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?

0 Answers   Wipro,


How do you start developing a datastage project?

0 Answers  


what is 'reconsideration error' and how can i respond to this error and how to debug this

0 Answers   Wipro,


State the difference between an operational datastage and a data warehouse?

0 Answers  


Categories