Answer / 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

Answer / phani kumar

With the help of available Environment variable as
APT_CHECKPOINT_DIR, we can run the job for remaining records.

This is available in Datastage Administrator like.....


With Datastage Administrator - project-wide defaults for
general environment variables, set per project in the
Projects tab under Properties -> General Tab -> Environment
variables.

Here, we can enable the this checkpoint variable. Then, we
can load the remaining records........

Answer / bharath

in datastage administrator we can enable add check point on failure option we can start from 401 record....

Answer / shar

ok now we have an reject job with stages like
seq--tx--dataset1 lets say job1

now take job2 (job) dependency from job1 to job2) in that
get the data from seq use tx as input 1 (primary) and dataset2 as secondary (ref) in which we use path of dataset1 file this as second input. now connect these inputs to lookup stage and reject the unmatched records connect the reject link to dataset3 in which file name should be same as dataset1 with update policy = append.



thats it dude.

Answer / abc

our design: src-->tfm-->data set.
to load the records from 401, just set the option Use Existing(discard records) in data set update action property

Answer / vinay sharma

1) First take seq file after that take one extra column in
that increment the value one by one and send to target
2) Now store the maximum value of extra column and pass this
value to transform thru HASH file and add in extra column
such as (sno+MAX)
Examlpe
SNO
1
2
3
4
5
6
7
Thera are max value is 7
Now add maxvalue means add 7 in SNO
like that
1+7
2+7
3+7
4+7
5+7
6+7
7+7

Answer / jagannath karmakar

USING SAVE POINT CAN PREVENT THIS PROBLEM

Answer / venkat

using an option called cleanup on failure

Answer / mukteswara rao

by usig
1. job level
2. job sequencing level

IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 Answers  

input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2

1 Answers   HCL,

What are the various kinds of the hash file?

0 Answers  

how to handle null values in sequential file?

1 Answers   HCL,

i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring

13 Answers   Bank Of America, IBM,

What is RCP?

2 Answers   TCS,

How can you write parallel routines in datastage PX?

0 Answers  

Highlight the main features of datastage?

0 Answers  

i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?

5 Answers   TCS,

How to reverse the string using unix?

0 Answers   CTS,

Hai..,in datastage how to explain project in interview?please explain any domain please.

1 Answers   Wipro,

Does datastage support slowly changing dimensions ?

0 Answers