Suppose Oza017.myorg.emp Has 100 Records ,oza018.myorg.staff Has 200

1.	Suppose Oza017.myorg.emp Has 100 Records ,oza018.myorg.staff Has 200 Records But 50 Are The Common Records In Both Files Copy All The Common Records Into Oza017.myorg.xyz Dataset?
Answer» IN SORT, YOU CAN USE JOINKEYS AND CAN TAKE 50 COMMON RECORDS IN B/W 2 I/P FILES AND WRITE TO O/P FILE. IN SORT, YOU CAN USE JOINKEYS AND CAN TAKE 50 COMMON RECORDS IN B/W 2 I/P FILES AND WRITE TO O/P FILE.

Suppose Oza017.myorg.emp Has 100 Records ,oza018.myorg.staff Has 200 Records But 50 Are The Common Records In Both Files Copy All The Common Records Into Oza017.myorg.xyz Dataset?

Answer»

IN SORT, YOU CAN USE JOINKEYS AND CAN TAKE 50 COMMON RECORDS IN B/W 2 I/P FILES AND WRITE TO O/P FILE.