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 9993What 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)
1896in 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 5163I 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 11179Hi 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 5990Hi 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 5077Hi 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 7742Hi 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 8235Hi 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 7865Post New IBM Data Stage Interview Questions
iam B.E 1year student,actually i have a habit i.e anything to think pratically but always iam in confusion what i have to do
How do you wrap text in word 2019?
what is active directory? : Windows server 2003
Can we store null in arraylist?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
What is .cs file in c#?
How to get execution path reports on query statements?
Why do we use spring bean?
What is your experience with Amazon website? How will you improve it?
What is difference between char array and string?
What are the steps involved in SAP Security upgradation projects and also in SAP security impletation projects
What is a thread (VC++) and state the difference between Cmutex and Csemaphone?
Is sorted c++?
How to enable initialize and script activex controls in mobile?
What is the old name of syndicate bank?