1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category
Data Stage Interview Questions
Questions Answers Views Company eMail

Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.

IBM,

1 5056

Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

IBM,

3 7714

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

Cap Gemini, IBM,

2 8208

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

CGI,

1916

how do you pass parameters in a script?

L&T,

1 6374

whats difference between ls -ltr and ls -lrt?

L&T,

5 37603

why do we need a datawarehouse when we have databases to store data?

L&T,

1 4680

i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?

L&T,

4 8266

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

L&T,

2 8050

whats relation between configuration file and datasets?

L&T, Wipro,

2 9984

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

ABC, TCS,

3362

what is diff b/w datastage 8.1,8.5,8.7?

IBM,

1 8866

how does work server jobs?

 1 3773

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

 2420

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

UHG,

4 9311

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the main differences you have observed between 7.x and 8.x version of datastage?

613

How can one find bugs in job sequence?

773

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...

1074

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

2713

What could be a data source system?

568




what is ds administrator used for?

710

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2262

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1113

How and where you used hash file?

648

Can you explain kafka connector?

764

What is merge stage?

754

how to abort the job its matain duplicates?

2091

What is meta stage?

568

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2530

What are the areas of application?

649

For More Un-Answered { Data Stage } Questions Click Here