Interested to Buy Any Domain ? << Click Here >> for more details...
I have a input as:
Col
1
1
2
2
3
I want 3 output as:
Output1:
1
1
Output2:
2
2
Output3:
3
i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help
- 9 Answers
- 14216 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / narayan
just add the mod function like this =MOD(inputcol|3) and then load into different targets
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why fact table is in normal form?
How do you import and export data into datastage?
What steps should be taken to improve Datastage jobs?
What is ds designer?
What are the steps needed to create a simple basic datastage job?
How can we improve performance of data stage jobs?
Difference between data warehousing and olap?
What are the main features of datastage?
what is the use of skid in reporting?
How to reverse the string using SQL?
What could be a data source system?
What can we do with datastage director?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
what are the devoleper roles in real time? plz tell i am new to datastage....
Difference between in process and inter process?
