it is possible to load two tables data into one sequential
file?if possible how?plz share with me?

Answer Posted / venugopal

Yes you can join two tables and load the data into
sequential file...
Take two tables use join stage and join the data based on
the key and then load the data into sequential file...

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

874


Differentiate between operational datastage (ods) and data warehouse?

937


How to RD using transformer?

1144


Define orabulk and bcp stages?

919


How can you write parallel routines in datastage PX?

833


Explain ibm infosphere information server and highlight its main features?

866


What is apt_config in datastage?

937


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2126


What is ds designer?

867


Where do you see different stages in the designer?

850


Explain datastage architecture?

1098


im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

1883


What is a merge in datastage?

990


Define project in datastage?

903


How do you import and export data into datastage?

986