Interested to Buy Any Domain ? << Click Here >> for more details...
my source seq file have
col1
1
2
3
4
5
6
7
8
9
i have 4 targets
t1 t2 t3 t4
1 2 3 4
5 6 7 8
9 like this how we can get?
- 10 Answers
- 17069 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / varaprasad
as for as i know,it is simple task only,
order is seq_file->column_generator->tfx->connect 4 targets.
in CG take one more column as SNO(anything)and goto extended column properties- take value=1,value=2,,,upto 4. now write constraint in tfx sno=1 goto t1
sno=2 goto t2...for all targets(4).
if u get other tahn this pls post answer
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
What are the functionalities of link partitioner and link collector?
What is the use of datastage director?
Can you explain tagbatch restructure operator?
How to find value from a column in a dataset?
What are the types of views in datastage director?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Explain ibm infosphere information server and highlight its main features?
how to delete one row in target dataset
Why do we use link partitioner and link collector in datastage?
What are the different common services in datastage?
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
What are the job parameters?
What are the different layers in the information server architecture?
Why do you need stage variables?
How can we improve the performance in datastage?
