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

if i have two tables
table1 table2
1a 1a,b,c,d
1b 2a,b,c,d,e
1c
1d
2a
2b
2c
2d
2e
how can i get data as same as in tables?chandu
how can i implement scd typ1 and type2 in both server and in parallel?chandu
field1 field2 field3
suresh , 10,324 , 355 , 1234
ram , 23,456 , 450 , 456
balu ,40,346,23 , 275, 5678
how to remove the ,inthe fields?


Question Posted / chandrasekhar.dasg

Answers were Sorted based on User's Feedback



if i have two tables table1 table2 1a 1..

Answer / pakkya

implement scd type1 -
simply overwrite with new data
implement scd type2 -
use merge stage to do an inner join on all columns after
sorting data, rows that do not join from merge result are
your changes
remove ',' - use Trim function with A option that removes
all occurences of ','

Is This Answer Correct ?    1 Yes 0 No

if i have two tables table1 table2 1a 1..

Answer / murari

By using the sort stage we can remove the duplicates by setting the option ALLOW DUPLICATES=FALSE......

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Data Stage Interview Questions

What are data elements?

0 Answers  

Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?

3 Answers   IBM, TCS,

what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,

What are the primary usages of datastage tool?

0 Answers  

in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5

3 Answers   IBM, YCS,

What is the differentiate between data file and descriptor file?

0 Answers  

What is orabulk stage?

0 Answers  

CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 Answers  

what is .dsx files

3 Answers   IBM,

Define project in datastage?

0 Answers  

Define repository tables in datastage?

0 Answers  

1)How to Duplicate Records Delete in Sequential file?

4 Answers   IBM, TCS,

For more Data Stage Interview Questions Click Here
Categories