I am running a job with 1000 records.. If the job gots
aborted after loading 400 records into target... In this
case i want to load the records in the target with 401
record... How will we do it??? This scenario is not for
sequence job it's only in the job Ex: Seq file--> Trans-->
Dataset..
Answer Posted / sree
by using look-up stage we can get the answer..
there are two tables like 1000 records(source) table and 400
records(target) table.
take the source table as primary table and 400 records table
as reference table to look-up table
reference table
.
.
.
source............. look-up......... target
Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
Explain ibm infosphere information server and highlight its main features?
What are the types of containers and how to create them?
project Steps,hits, Project level HArd things,Solved methods?
why do u need the IOS upgradation in a FC switch
What are the different plug-ins stages used in your projects?
What are the components of datastage?
Terminate Activity
Where do the datastage jobs get stored?
Can you define merge?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What are the types of hashed files in data stage
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What is the method of removing duplicates, without the remove duplicate stage?
What are the primary usages of datastage tool?
Which warehouse using in your datawarehouse