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 6912

why dataset ?

2 5996

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

3166

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

IBM,

2261

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 8122

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

IBM,

2 20056

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 9997

how to change left and right links in join stage?

Cap Gemini, IBM,

4 10371

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

Accenture,

2 9106

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 10204

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 9611

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 6121

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 12379

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,

2384

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

Bank Of America, Satyam,

2 22225


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are stage variables, derivations and constants?

1224


If you want to use a same piece of code in different jobs, how will you achieve this?

1276


Can we use target hash file as a lookup ?

3326


what is the use of skid in reporting?

2381


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3650


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

1037


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

2285


options available in sequence job to run,validate?

1316


Define APT_CONFIG in Datastage?

1080


What are the difference types of stages?

1214


Difference between ‘validated ok’ and ‘compiled’ in data stage?

1277


Define project in datastage?

1093


Why do we use exception activity in Datastage?

1314


What are the enhancements made in datastage 7.5 compare with 7.0?

1148


which r the connectors used in san?

2188