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
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com
What are the benefits of data analyzing?
How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?
What parallelisms does Abinitio support?
What dedup-component and replicate component does?
Explain about ab initio’s dependency analysis?
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?
What is sort component in abinitio?
Mention what information does a .dbc file extension provides to connect to the database?
What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?
Explain what is sort component in abinitio?
Have you used the rollup component? Describe how?
What is the purpose of having stored procedures in a data-based?
How to add default rules in transformer?