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...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

i hav source like this .
deptno,sal
1,2000
2,3000
3,4000
1,2300
4,5000
5,1100
i want target like this
target1
1,2000
3,4000
4,5000
target2
2,3000
1,2300
5,1100 with out using transformer

Question Posted / jhansi

Answers were Sorted based on User's Feedback



i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target ..

Answer / hari chowdary

by using partition technique round rabin we can do easily.
single source table,two target tables

Is This Answer Correct ?    16 Yes 1 No

i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target ..

Answer / pranay

____tgt1
|
|
source------transformer---
|
|
-----tgt2


in transformer

TGT1 ---
constraint --> mod(deptno,2) = 1
source.deptno - deptno
source.sal - sal

TGT2 ---
constraint --> mod(deptno,2) = 0
derivation -->
source.deptno - deptno
source.sal - sal

u'll get the ans, if i'm wrong plz correct me

Is This Answer Correct ?    6 Yes 11 No

Post New Answer

More Data Stage Interview Questions

I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,

How the ipc stage work?

0 Answers  

Can you explain link buffering?

0 Answers  

Can you explain tagbatch restructure operator?

0 Answers  

how to create document in datastage?

1 Answers   Cap Gemini,

How can u write exception handling in seq file????

2 Answers   IBM,

Explain the functionality of your current project?

1 Answers   IBM, Miles Software,

How can we run same job in 1 day 2 times

7 Answers   IBM,

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

2 Answers   TCS,

Where do the datastage jobs get stored?

0 Answers  

how many write modes are there in ds

2 Answers   IBM,

my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

3 Answers   TCS,

For more Data Stage Interview Questions Click Here
Categories