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 |
What are system variables and sequencers in datastage
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
Describe link sort?
what is the use of surogate key in datastage
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.
Tell me the syntax of Configuration file?
What are operators in datastage?
how many types of sorting the data in data stage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
What are iconv and oconv?
options available in sequence job to run,validate?