i have one table with one column in this column i have three
rows like 1,1,2 then that rows populate to target as first
tow rows as one row and remaing row as one row how it posible?
COLUMN_NAME
SHIVA
RAMU
MADHU
THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND
MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME
- 3 Answers
- 8635 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / raj
Use a pivot stage
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why do we use exception activity in Datastage?
Describe the main features of datastage?
What is ibm datastage?
how many rows sorted in sort stage by default in server jobs
What are the types of containers in datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is a folder? Difference types of stages?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are the main differences you have observed between 7.x and 8.x version of datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
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 ?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
whom do you report?
What are iconv and oconv?
What is oci?
