You can ask about - meta pivot, leading records, read & write multiple files component ? How to use in abinitio graph?
Answer Posted / ankan
Meta Pivot splits records by data fields (columns), converting each input record into a series of separate output records. There is one separate output record for each field of data in the original input record. Each output record contains the name and value of a single data field from the original input record.
Leading Records copies a specified number of records from its in to its out port, counting from the first record in the input file. We can Specify the number of records to copy from in port to out port.
Read Multiple Files reads records from the in port, calls a transform function to get the name of a local file from each input record, reads records from the files, and writes these records to the out port.
Write Multiple Files reads input records and derives a local filename from each single record. Each input record is written to the designated local file, passing through an optional transform function.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is data warehousing different from data mining?
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?
How can you export a component’s internal parameters ?
What is the difference between look-up file and look-up, with a relevant example?
Explain what is sort component in abinitio?
Mention what information does a .dbc file extension provides to connect to the database?
What is common among data validity and data integrity?
What is the purpose of having stored procedures in a database?
How can you force the optimizer to use a particular index?
How to move or copy the project parameter or project object to my sandbox?
Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?
The methods to improve performance of a graph?
How you can run a graph infinitely in ab initio?
explain the environment varaibles with example?
Name the different type of processing based on the steps that you know about?