Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

source
1123445
I WANT OUTPUT AS
DUPLICATES TO TARGET1 LIKE
TARGET1
1144
NON-DUPLICATES TO TARGET2
TARGET2
235

Answer Posted / shreeram

Seq(source)------> Transform stage-------> Tgt1
!.........>Tgt2


use substring in transform stage.

Is This Answer Correct ?    0 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is usage analysis in datastage?

1301


options available in sequence job to run,validate?

1314


How do you schedule or monitoring the job?

1204


Define orabulk and bcp stages?

1119


if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2227


Where the datastage stored his repository?

1087


Describe link sort?

1011


Describe routines in datastage? Enlist various types of routines.

1009


If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2046


What are the processing stages?

1099


What are routines in datastage?

1325


what is flow of project?

1999


What is the sortmerge collector?

1130


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2862


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1387