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 A Datastage?

2 4943

1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

Hexaware,

1 6651

What is Horizontal transformation, vertical transformation,diagonal transformation?

Cap Gemini,

2 9863

Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?

TCS,

1 4298

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?

TCS,

3 10051

I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage

IBM,

3 9260

How can remove duplicates in a file using UNIX?

Cap Gemini,

3 12258

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

TCS,

1 6622

What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

Hexaware,

1 6343

how to configure databases through datastage

2 12355

hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...

5 9679

Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x

7 11276

how to retrive the max(sal),deptno,empno in datastage?

Polaris,

13 24510

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?

Polaris,

10 17198

how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?

Accenture,

3 23748


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the types of hashed files in data stage

1108


Is possible to create skid in dim,fact tables?

2642


What are the stages in datastage?

1085


How many types of views are there in a datastage director?

1296


Describe stream connector?

1312


Could anyone give brief explanation bout datastage admin

2356


What are constraints and derivations?

1174


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

2188


What is the purpose of pivot stage?

1172


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

1088


Differentiate between hash file and sequential file?

1077


How to implement complex jobs in data stage?

1116


How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1509


How many types of sorting methods are available in datastage?

1075


What are the job parameters?

1223