1. Categories >> Software >> Data Warehouse >> Data Stage
  2. 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

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

More Data Stage Interview Questions

where we use config file as parameter ?

1 Answers   IBM,

I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers   Accenture,

what is the diff b/w switch and filter stage in datastage

2 Answers   Cap Gemini,

3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 Answers  

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

1 Answers   IBM,




Difference between server jobs & parallel jobs?

0 Answers  

How can remove duplicates in a file using UNIX?

3 Answers   Cap Gemini,

Please tell me What is difference between 8.0 and 8.1

1 Answers   IBM,

If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers  

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

2 Answers   Wipro,

i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers   IBM,

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

0 Answers   IBM,

For more Data Stage Interview Questions Click Here
Categories