file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2

Categories >> Software >> Data Warehouse >> Data Stage
Suggest New Category

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

Question Posted / sameer

5 Answers
13868 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 ..

Answer / subhash

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

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 ..

Answer / shar

ok
Follow this:

seqStg1,seqStg2-->Funnel-->Filter-->seq1,seq2,seq3.

Since we have less data to sort and to remove duplicates use
hash partition and unique option at input link.

Thats it.

I wonder why such a goofy question asked by capegemini?

Is This Answer Correct ?

9 Yes

4 No

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 ..

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

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 ..

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

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 ..

Answer / prabhu rathnam

Seq1,Seq2--->join--->removeduplicate---->filter--->trg1,trg2,trg3

Is This Answer Correct ?

0 Yes

0 No

Post New Answer