Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.6 7991
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)1548
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 4401
I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help8 8608
Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.2 5163
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.1 4396
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 Thanks3 6415
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 Thanks2 7022
what is diff b/w datastage 8.1,8.5,8.7?1 8215
What is difference between 8.1 , 8.5 and 9.1 ?1 14197
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??1 7193
how to call sequential generator in datastage?1 3111
which is the most complex job in your career? Please tell me answer?2 5585
how many types of sorting the data in data stage?1 5379
How are they maitained?
What is EventEmitter in Node.js?
What is boot method in laravel?
What is max rowid in oracle?
explain various problem solving statagis
What is window 7 and its features?
How far can a network go? (the distance problem)?
what is the transmission loss for electrical supply? specifically a large shopping complex where the grid is half KM away, what will the % of transmission loss? is there any transmission loss for captive unit generation for above set? thanks
what do you mean by automatic a/c determination? What data do you need for it?
what are the layers of the national and heir aprox thickness??
In how many ways can dependency injection be done?
What is virtual destructor ans explain its use?
What is the most frequent metric to assess model accuracy for classification problems?
Please tell us what is the difference between override and overload in a method?