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

What is the difference between lookup and sparse lookup?

1 6992

why dataset ?

2 6118

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3214

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

IBM,

2323

How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

TCS,

2 8219

How to convert table data into xml file using xml output stage? please explain step by step;

IBM,

2 20163

Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S

3 10130

how to change left and right links in join stage?

Cap Gemini, IBM,

4 10543

what is meant by port ? what is the use of port ? what are the different type of ports and its usage

Accenture,

2 9210

Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)

HSBC,

3 10397

A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise

Polaris,

3 9735

Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain

2 6224

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

IBM,

6 12618

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

IBM,

2444

How to remove ctrl M or(^M) characters in file using Sequential File stage?

Bank Of America, Satyam,

2 22355


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Notification Activity

1460


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2780


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2247


What is the difference between server job and parallel jobs?

1200


Name the command line functions to import and export the DS jobs?

1200


Define Job control?

1226


Can you filter data in hashed file?

3826


if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2285


Explain usage analysis in datastage?

1224


What is the use of datastage director?

1073


How to reverse the string using unix?

3593


How can you write parallel routines in datastage PX?

1065


explain about citrix scheduling tool in datastage

2509


How do you start developing a datastage project?

1160


On which Dimension Table you implemented SCD Type in your Project

2113