Interested to Buy Any Domain ? << Click Here >> for more details...
Source flat file contains
src
---
1
2
'
'
'
18
we had 3 targets
T1 T2 T3
-- -- --
1 4 7
2 5 8
3 6 9
10 13 16
11 14 17
12 15 18
How can i get?
**Using only datastage, but not unix or any other.
I am expecting the answer soon..
Thanks in advance.
- 7 Answers
- 10597 Views
- I also Faced
- E-Mail Answers
Answer Posted / pranay
source----->transformer----->filter------>T1
|
|
--------->T2
|
|
--------->T3
Transformer:
1.drag source column to target.
2.append new column in transformer target as new and apply derivation Mod(input column, 3).
Filter:
where condition1 new = 1
condition2 new = 2
condition3 new = 0
Name the three targets T1, T2, T3.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Differentiate between Join, Merge and Lookup stage?
what is flow of project?
what are the devoleper roles in real time? plz tell i am new to datastage....
explain about citrix scheduling tool in datastage
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are the important features of datastage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Define Routines and their types?
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 stage variables and constants?
State the difference between an operational datastage and a data warehouse?
What are the some differences between 7.x and 8.x version of datastage?
How will you move hashed file from one location to another location?
root tree will find which is server job and which is parallel job?
How many types of hash files are there?
