Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is
Empno
1
2
3
4
5
6
7
8
9
10
Answer Posted / soumya
Use pivot Stage.
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
Nls stands for what in datastage?
What is the difference between datastage and informatica?
How one source columns or rows to be loaded in to two different tables?
What is difference between symmetric multiprocessing and massive parallel processing?
What are data elements?
What are constraints and derivations?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
how to abort the job its matain duplicates?
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.
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is the difference between in process and inter process?
How many types of stage?
How many areas for files does datastage have?
What are the different options associated with dsjob command?
What is job control?