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

What is apt_config in datastage?

0 Answers  

what is the difference between the active datawarehouse and datawarehouse

1 Answers   TCS,

What are the different common services in datastage?

0 Answers  

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

3 Answers   TCS,

we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

1 Answers   HSBC, NTT Data,

Can we use target hash file as a lookup ?

0 Answers  

how many datamarts we will use in real time project and when will use the datamart?pls send the replay early

2 Answers   Tech Mahindra,

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers   TCS,

Whats difference betweeen operational data stage (ods) and data warehouse?

0 Answers  

What is the difference between datastage and datastage tx?

0 Answers  

Terminate Activity

0 Answers   CTS,

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

1 Answers   Wipro,

For more Data Stage Interview Questions Click Here
Categories