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

Answer Posted / amit

Two tables means, there is a possibility of mismatching metadata. In this case also, we can load data into a sequential file without maintaining the metadata of two tables.

If we want to keep track of these records, then we can, add one record identifier field, to later identify the records while extracting data from file.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many areas for files does datastage have?

881


Can you explain link buffering?

945


What is the difference between orabulk and bcp stages?

801


How one source columns or rows to be loaded in to two different tables?

909


What are the differences between datastage and informatica?

882


how to delete one row in target dataset

2860


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1278


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

1969


What is a merge?

873


What are the different plug-ins stages used in your projects?

860


Describe link sort?

837


What are the various kinds of containers available in datastage?

809


how can we create rank using datastage?what is the meaning of rank?

8464


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

819


Nls stands for what in datastage?

970