Answer Posted / manu
By using 'ETERNAL PIVOT STAGE' we can do this
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Which algorithm you used for your hashfile?
In Datastage, how you can fix the truncated data error?
What are iconv and oconv?
How many types of views are there in a datastage director?
What is the difference between datastage and informatica?
What is the purpose of interprocessor stage in server jobs?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
how to implement scd2 in datastage 7.5 with lookup stage
What is the method of removing duplicates, without the remove duplicate stage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What are system variables and sequencers in datastage
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
how do u catch bad rows from OCI stage? And what CLI stands for?
Difference between in process and inter process?