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 a source file is populated?

620


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2013


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1141


What is the command line function to import and export the ds jobs?

681


How you Implemented SCD Type 1 & Type 2 in your project?

3699






What are the different types of lookups in datastage?

631


Highlight the main features of datastage?

615


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

1920


Explain the situation where you have applied SCD in your project?

1562


Name the different sorting methods in datastage.

613


What is orabulk stage?

636


What is difference between server jobs & parallel jobs?

625


If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

1631


Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1120


What is process model?

1553