ALLInterview.com :: 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
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none    0  27
how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?    0  16
Could anyone give brief explanation bout datastage admin    0  14
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    5  83
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  52
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  52
Explain the scenarios where sequential file stage runs in parallel?    0  50
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise    0  60
how to call sequential generator in datastage?    0  44
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   4  133
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   3  123
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know    1  144
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  558
Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this?? ibm   1  293
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   8  1201
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
 
Sorce contins the metadata sorce ----- hyderabad,chennai,banglore by using nested loop sequence select sourch as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence) 316
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction? 207
How to find value from a column in a dataset? 109
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES? 1711
How many Nodes configuration file you used in your last project? 304
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage. 258
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ? 214
how to create document in datastage? 626
Explain the scenarios where sequential file stage runs in parallel? 50
how to delete one row in target dataset 535
disign the complex job in u r project?(they are aksing only complex job design and then data flow...) 278
Different ways a project can be moved to production ?...example ….export-import and Version control. 187
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction? 207
1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project 362
how to implement scd2 in datastage 7.5 with lookup stage 947
E-Mail New Answers        Answer Selected Questions