How do u convert the columns to rows in datastage?
No Answer is Posted For this Question
Be the First to Post Answer
What are the types of views in datastage director?
HOW CAN WE SEE THE DATA IN DATASET?
12 Answers IBM, TCS,
Explain how a source file is populated?
how to handle null values in sequential file?
Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?
What are stage variables, derivations and constants?
What are transforms and what is the differenece between routines and transforms?
How you Remove the Dataset in Unix?
How to reverse the string using unix?
if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
What is merge stage?