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

How To find the location of APT_confid file

CTS,

2 8956

Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?

Wipro,

4 13621

what is parameterset?

Wipro,

4 11168

j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?

Wipro,

1 6858

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

Wipro,

2213

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

Wipro,

2622

1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?

Wipro,

7 19950

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

Wipro,

2025

Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?

3 12589

Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

HCL,

1 4858

A flat file 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 this job?

TCS,

1 8336

I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?

TCS,

1 6594

Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?

IBM, TCS,

3 13812

Give example for FACTLESS FACT TABLE in real-time scenario.

TCS,

4 19019

How many jobs in ur project? Explain any complex job u have done in ur project?

IBM, TCS,

1 5216


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the difference types of stages?

1218


Define data aggregation?

1105


How do you schedule or monitoring the job?

1210


How do you register plug-ins?

969


Explain datastage architecture?

1405


How to implement complex jobs in data stage?

1116


What is a merge in datastage?

1272


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

2267


Differentiate between datastage and datastage tx?

1059


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


What is staging variable?

1100


What are the different layers in the information server architecture?

1129


How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2622


Which warehouse using in your datawarehouse

2191


What are the steps needed to create a simple basic datastage job?

1242