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
input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2    1  20
What is the difference between Link collector and Funnel Stages?    0  25
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.    1  45
I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?    1  139
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.    1  179
in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5    2  132
in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh    0  76
If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records    0  82
Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is  Empno 1                                2 3 4 5 6 7 8 9 10                                                                                                 5  1995
hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer     0  478
how many types of remove the duplicate records?    3  1758
how many types of sorting the data in data stage?    1  1912
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?    4  2119
which is the most complex job in your career? Please tell me answer?    1  1711
i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output  aaa bbbb ccccc Ple help any one?    3  3685
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
 
what are the devoleper roles in real time? plz tell i am new to datastage.... 395
how to delete one row in target dataset 1187
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? 609
why do u need the IOS upgradation in a FC switch 573
I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv(). 550
in oracle target stage when we use load option and when we use upsert option? 431
what is 'reconsideration error' and how can i respond to this error and how to debug this 774
Could anyone give brief explanation bout datastage admin 625
what is the use of surogate key in datastage 394
Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me 327
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ? 535
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys 1196
How can we select pr retrieve the particular row in dataset by using orchadmin command? 1259
How you Implemented SCD Type 1 & Type 2 in your project? 1604
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 664
E-Mail New Answers        Answer Selected Questions