In aggregator stage,to find the sum of the entire group of
columns,it displays in binary format. How can i solve this
problem.
Answer / kiran
hai..
Binary Format not support in Aggregate Stage
Is This Answer Correct ? | 4 Yes | 0 No |
Unix command to view the data in a dataset
How many Key we can define in remove duplicate stage?
why do u need the IOS upgradation in a FC switch
What are routines in datastage?
how to design the change capture stage in(data stage parallel jobs) type 2
my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?
How can one find bugs in job sequence?
how can we create tables in datastage?
what is a message handler
describe the Steps to confiure a Qlogic switch
Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari
I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3