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

I have file with empid,empname and I want to load these two
fields along with sal in my target
1)salary must be same for all the records
2)I want pass the salary at run time

Answer Posted / madhu

This can achieve using xmf stage, in create one extra column
as sal and data pass through parameter


Seq----> xmf---> dataset

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe routines in datastage? Enlist various types of routines.

954


Where do you see different stages in the designer?

1034


Can you explain players in datastage?

1142


Differentiate between validated and Compiled in the Datastage?

1193


Give an idea of system variables.

962


What are the various kinds of the hash file?

1095


file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

887


What is usage analysis in datastage?

1262


What is the use of hoursfromtime() function in transformer stage in datastage?

999


How can one find bugs in job sequence?

1316


What is ds designer?

1030


How can we improve performance of data stage jobs?

966


What are stage variables?

1138


Can you explain how could anyone drop the index before loading the data in target in datastage?

1439


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3733