how to convert rows into columns

Question Posted / guest

2 Answers
12159 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to convert rows into columns..

Answer / sanjeeva reddy

PIVOT STAGE

Is This Answer Correct ?

10 Yes

4 No

how to convert rows into columns..

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

Post New Answer

More Data Stage Interview Questions

HOW CAN U DO ERROR HANDLING IN DATA STAGE?

8 Answers ME,

How to Remove Duplicate using SQL?

0 Answers CTS,

What is a merge in datastage?

0 Answers

What are routines in datastage? Enlist various types of routines.

0 Answers

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.

8 Answers

How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 Answers TCS,

What is the command line function to import and export the ds jobs?

0 Answers

What is the purpose of pivot stage and types of containers in datastage

0 Answers

Difference between ‘validated ok’ and ‘compiled’ in data stage?

0 Answers

In a table 100 records are there after 50records job is aborted how can u insert all records in target table.

1 Answers Cap Gemini,

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

2 Answers

How a source file is populated?

0 Answers

For more Data Stage Interview Questions Click Here