1)Source file contains one record, I want 100 records in
target file.
Answer Posted / salendra
By usng pivot stage it can be solved
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
Can you explain kafka connector?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What is the difference between validated and compiled in the datastage?
What can we do with datastage director?
What is active and passive stage?
What is the difference between datastage and informatica?
What is the command line function to import and export the ds jobs?
What are the different kinds of views available in a datastage director?
What is the difference between server job and parallel jobs?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is oci?
Name the third party tools that can be used in datastage?
What are constraints and derivations?
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
Name the different sorting methods in datastage.