1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / venkatreddy786


Hi all, explain one complex business rule that you had in your project and how did you accomplish..

Answer / datastage4you

explain any scenario which you have faced

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Data Stage Interview Questions

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)

3 Answers   HSBC,

Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

1 Answers   Alpharithm Technologies,

What can we do with datastage director?

0 Answers  

how to sort two columns in single job in datastage.

1 Answers   TCS,

tell me abt Datastage trigger?

1 Answers   HP, IBM,




In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario

3 Answers  

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

0 Answers  

Wat is pre-load in Hashed file

1 Answers   Patni,

in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.

1 Answers   IBM,

Differentiate between hash file and sequential file?

0 Answers  

How do you run datastage job from the command line?

0 Answers  

What are the third party tools you used in your project?

1 Answers   IBM,

For more Data Stage Interview Questions Click Here
Categories