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 12073What 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)
2330in 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 5820I 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 13610Hi 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 6800Hi 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 5774Hi 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 8947Hi 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 9444Hi 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 8493Post New IBM Data Stage Interview Questions
How to create context?
What is zigbee protocol for the internet of things (iot)?
The extract statements in field groups can be used before or after processing the sort statements. State true or false. : abap modularization
What are real-time systems?
tel me someting about your past
What are the steps to install windows operating system?
What do you mean by jstl?
Kindly post me previous year interview questions with answer for post of DY. Manager (civil engg.) for GAIL, NTPC, IOC, OIL and ONGC etc.
How do you create a program in excel?
What does windows 7 system restore do?
What are Home Equity Loans ?
How To Servers For Malitnationl Bank?
which are the string manipulation opcodes?
The purpose of the Initiation process is to: A. Formally recognize the existence of a project or project phase B. Formally recognize the need that brought about the project be it marketing demand, customer requests, business need, technological advances, or legal requirements C. Formally recognize the stakeholders of the project and identify them in the project charter D. Formally recognize the project sponsor and document his or her project goals