Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
3130How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?
TCS,
2 8013How to convert table data into xml file using xml output stage? please explain step by step;
IBM,
2 19928Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S
3 9842what is meant by port ? what is the use of port ? what are the different type of ports and its usage
2 8911Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)
HSBC,
3 9987A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
3 9487Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain
2 5988Input 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.
IBM,
6 12068What 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)
IBM,
2328
What is the flow of loading data into fact & dimensional tables?
How many Key we can define in remove duplicate stage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What is the difference between server job and parallel jobs?
What are the steps needed to create a simple basic datastage job?
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)
What are the difference types of stages?
what is the use of materialized view?
Difference between sequential file and data set?
How to convert RGB Value to Hexadecimal values in datastage?
Notification Activity
What are some different alternative commands associated with "dsjob"?
What is the difference between informatica and datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Explain entity, attribute and relationship in datastage?