in datastage interview qustion
source target
------- -------
12345 1
2
3
4
5
Answer Posted / np
Use Pivot stage
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Differentiate between Join, Merge and Lookup stage?
State the difference between an operational datastage and a data warehouse?
Why do you need stage variables?
What are the different options associated with dsjob command?
Nls stands for what in datastage?
How do you remove duplicate values in datastage?
How you Implemented SCD Type 1 & Type 2 in your project?
Explain ibm infosphere information server and highlight its main features?
table actions available in oracle connector?
What is process model?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What steps should be taken to improve Datastage jobs?
Difference between server jobs & parallel jobs?
what is the use of materialized view?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2