I am having 10 records in i/p file,and i want to load only
one record at a time to the output file.Then how can i do it?
Answers were Sorted based on User's Feedback
Answer / ankur
Output file component in serial layout will always be written serially by any upstream abinitio component.
If you meant Output Table component instead of Output file, then API mode will ensure that the load happens sequentially.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / keerthika
You can use the partition by round robin component and specify Block size parameter to 1.
| Is This Answer Correct ? | 1 Yes | 2 No |
What is the difference between partitioning with key and round robin?
How can you export a component’s internal parameters ?
What is the difference between a scan component and a rollup component?
What do you understand by local lookup?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
What is the difference between formal and export parameter? Export at what secenario we are going to use?
Describe which system or process elements you would review when trouble-shooting general server slows ?
If I delete 1 partition (in 8 partition multifile) and run the graph. Will the graph run successfully?, If not what error I'm going to get.
How co> operating system natively processes the data?
How might you quantitatively measure an improvement made to a query?
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
Name the different type of processing based on the steps that you know about?