Interested to Buy Any Domain ? << Click Here >> for more details...
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..
- 9 Answers
- 31374 Views
- Cognizant, IBM, TCS, Virtusa, I also Faced
- E-Mail Answers
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
How to clean the datastage repository?
How many types of views are there in a datastage director?
Explain usage analysis in datastage?
How do you schedule or monitoring the job?
Define APT_CONFIG in Datastage?
Difference between data warehousing and olap?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is the process of killing a job in datastage?
What is the difference between odbc and drs stage?
Where do the datastage jobs get stored?
Difference between ‘validated ok’ and ‘compiled’ 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
How to read the length of word in unix?
What is merge stage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
