Explain ibm infosphere information server and highlight its main features?
No Answer is Posted For this Question
Be the First to Post Answer
Differentiate between data file and descriptor file?
Hi Vijay here For Four CPU's how many nodes will required?
What are the partition techniques available in your last project?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
how to change left and right links in join stage?
how to run jon in unix back round process what is command use in runing a job?
How do u convert the columns to rows in datastage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.
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.
How to Convert a string function to date function by using only sequential file stage with out using other stages ?