:: Home Page      
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   Errors
   Testimonials Refer this Site  Refer This Site to Your Friends  Site Map  Contact Us      
 Categories >> Software >> Data Warehouse >> Data Stage
Suggest New Category 


Question Asked @ Answers Views     Select
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid   salary   previoussalary 10      1000     null 20      2000     1000 30      3000     2000       40      4000     3000    3  36
hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"  hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(    1  27
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on    0  39
Explain the scenarios where sequential file stage runs in parallel?    0  34
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise    0  36
how to call sequential generator in datastage?    0  30
My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this. wipro   3  88
Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del hcl   2  80
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know    1  111
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????    4  516
Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be to do this?? ibm   1  258
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage? cognizent   7  1148
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks cap-gemini   3  986
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys    0  174
My input has a unique column-id with the values 10,20, can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file? wipro   2  662
E-Mail New Answers        Answer Selected Questions        Post New data-stage Questions
 [1]    2  ... 4   ... 7   ... 10   ... 13   ... 16   ... 19   ... 22   ... 25   ... 28   ... 31   ... 34   ... 37   ... 40    Next
Un-Answered Questions
 Question Views   Select
how to create document in datastage? 614
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also 378
Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive. 246
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS? 222
Is it possible to query a hash file? 192
what is 'reconsideration error' and how can i respond to this error and how to debug this 234
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ? 208
I have a few records just I want to store data in to targets cycling way how? 188
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. 204
How to find value from a column in a dataset? 102 record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do 230
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this? 140
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks. 136
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase? 189
what are the different type of errors in datastage? 1152
E-Mail New Answers        Answer Selected Questions