1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output
0utput1: ABD
output2: V
any one suggest me this

Question Posted / narayana


I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V a..

Answer / Tabassum

This problem seems to be a join between two tables. To get the desired output, you can perform an outer join between F1 and F2 tables on columns C and E. The resulting output would include all rows from F1 (output1: ABD) and any matching rows from F2 (output2: V).

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?

2 Answers   Mannar Company, ME,

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers   IBM,

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

2 Answers  

in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....

4 Answers  

What is the difference between an operational datastage and a data warehouse?

1 Answers  

If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

5 Answers   Infotech,

how to call routines in stages?

3 Answers   ME,

On which interface you will be working as a developer?

1 Answers  

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,

if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

17 Answers   IBM, TCS,

on how many columns we can perform aggregation in the Aggregator stage?

3 Answers   Reliance,

What is diff between Junk dimensions and conform dimension?

4 Answers   Polaris,

For more Data Stage Interview Questions Click Here
Categories