file1
1
2
3
4
file2
3
4
5
6
output should be in three targets
T1 T2 T3
1 3 5
2 4 6
how to do this? can any one help?
Thanks
Answers were Sorted based on User's Feedback
Using change capture stage:
File1(Master),File2----> change capture---> Filter ---->
T1, T2, T3
In Filter,
Change_code=1 then send then to T1-->(Insert records)
Change_code=0 then send then to T2-->(Copy records)
Change_code=2 then send then to T3-->(Delete records)
Is This Answer Correct ? | 24 Yes | 1 No |
Answer / yuvraj
This can be done using change capture stage:
Seq1,Seq2 ----> change capture (here keep Drop Output for
copy : False) ---> Filter ----> seq1,seq2,seq3
from this above output will get
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sekhar
Use Full outer join and propagate left and right links into transformer.If records are not matched nulls will be populated.Identify nulls in both left and right links you will get two target and for third target just write in Contraints-isnotnull(leftlink and rightlink)-Target 2
-Isnull(leftlink.Inputcolumn)-Target1
-Isnull(Rightlink.Inputcolumn)-Target3
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / prabhu rathnam
Seq1,Seq2--->join--->removeduplicate---->filter--->trg1,trg2,trg3
Is This Answer Correct ? | 0 Yes | 0 No |
Unix command to view the data in a dataset
I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A
What are iconv and oconv?
How do you import and export data into datastage?
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
In one project how many shared containers are created?
what is the definitions for Datawarehose and Datamart?
Can you filter data in hashed file?
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 is a ds designer?
How many number of reject links merge stage can have?