how to convert rows into columns
Answers were Sorted based on User's Feedback
Answer / swetha
BY using Pivot stage convert rows into columns in
datastage.If we want to change in informatica we use
normalizer transformation.
| Is This Answer Correct ? | 11 Yes | 6 No |
How will you move hashed file from one location to another location?
How to read multiple files using a single datastage job if files have the same metadata?
hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(
How do you register plug-ins?
eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000
I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.
what is repositery?
Can we use Round Robin for aggregator?is there any benefit underlying?
HOW CAN WE SEE THE DATA IN DATASET?
Difference between sequential file and data set?
Define Data Stage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?