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

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

Cap Gemini, TCS,

3296

what is the exact difference between dataset and fileset in datastage?

TCS,

5 46102

i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

ABC,

1 6572

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

2 7649

Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5

IBM,

2 11286

how to sort two columns in single job in datastage.

TCS,

1 11173

how to sort two columns in single job in datastage.

TCS,

2958

how to sort two columns in single job in datastage.

TCS,

1 8017

Which warehouse using in your datawarehouse

IBM,

2239

Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance

IBM,

2 17160

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?

TCS,

3 9666

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 7563

souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 12555

How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?

3 9570

guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.

TCS,

2 7922


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the difference between hashfile and sequential file?

1321


Describe stream connector?

1360


Define oconv () and iconv () functions in datastage?

1471


Where do you see different stages in the designer?

1146


What are system variables and sequencers in datastage

1183


Difference between data warehousing and olap?

1151


How can we improve performance of data stage jobs?

1070


What is the purpose of pivot stage and types of containers in datastage

1082


How do you reject records in a transformer?

1178


What is the difference between operational data stage (ods) and data warehouse?

1295


What are the functionalities of link partitioner?

1068


How to reverse the string using SQL?

1597


What are the difference types of stages?

1287


why do u need the IOS upgradation in a FC switch

2339


What is the flow of loading data into fact & dimensional tables?

1113