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 do you generate sequence number in datastage?

878


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

2138


how to add a new records into source?

1771


what is the use of materialized view?

1251


What is the difference between server job and parallel jobs?

946


How can we improve the performance in datastage?

898


How to reverse the string using unix?

3201


What is datastage engine?

980


What is the flow of loading data into fact & dimensional tables?

853


What is a datastage job?

824


Name the different sorting methods in datastage.

842


Why do we use link partitioner and link collector in datastage?

934


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2519


Terminate Activity

1087


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

1988