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 12384What 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)
2385in 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 5906I 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 help
9 13945Hi 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 6919Hi 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 5870Hi 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 Thanks
3 9099Hi 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 Thanks
2 9625Hi 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 8564Post New IBM Data Stage Interview Questions
Is it possible to hide f4 function for an input element programmatically?
The job profile as a Service Engineer?
I want to validate Customer credit payment with customer invoice, When billing time, the system check the customer credit payment, if customer credit is lesser than customer bill, system should not allow the billing further process. Can I configure in sap
What is loosely coupling in spring?
What is the next version of windows after 10?
What is the use of AWS redshift driver?
define as synchronous generator
Describe exception handling concept with an example?
I want to know that , If we called a person for one day for drive our company van or any other purpose. so how it will accounted in our (i.e companies) Books of accounts....
How to I prevent other users from using Kryptel (Silver Key)?
Does google have a database program?
What are the Types of JIT and what is econo-JIT
Is servlet a controller?
Anything special you should do when adding a user that has a mac?
What are the advantages of internet marketing?