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

Data Stage Interview Questions
Questions Answers Views Company eMail

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? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

IBM,

2133

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.

Teradata,

6 12760

how many write modes are there in ds

IBM,

2 11330

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

Gallega, TCS,

5 14865

can a fact table contains textual information

HCL, HCL BSERV, IBM,

6 14013

difference between function and procedure...

IBM,

1 6118

if ename='subbu' while running job the job should be abort how come?

IBM,

3 8506

how to find diff between 2 dates without using Icon... funtions?

1 3580

how to find no.of records in sequntial file itself?

4 21473

i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 5926

ename like ibm,tcs,hcl need display those records only how?

2 6312

convert yyyy mm dd to dd mm yyyy?

4 16029

how to closeing records after 10,000 records come?

3 6192

how to add a new records into source?

1937

in oracle target stage when we use load option and when we use upsert option?

2208


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2217


What are the types of hashed files in data stage

1062


How to read multiple files using a single datastage job if files have the same metadata?

1180


What are the some differences between 7.x and 8.x version of datastage?

1207


What is the precedence of stage variables,derivations, and constraints?

1034


what is use of SDR function?

5130


what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1032


How can you write parallel routines in datastage PX?

976


What are the benefits of datastage?

1181


How the ipc stage work?

1082


how to implement scd2 in datastage 7.5 with lookup stage

5555


Where do the datastage jobs get stored?

1154


Nls stands for what in datastage?

1148


What are the different options associated with dsjob command?

1376


Differentiate between odbc and drs stage?

1000