How to load the data from an excel sheet to input file in a
graph?
Answer Posted / guillermo villarreal
You can save the spreadsheet as *.csv then write the data
layout as comma delimeters. You may skip the first record
which may have all header column names.
Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
What is a rollup component? Explain about it.
What do you know about partition and also tell us about partition components in abinitio?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
What is m_dump?
What is is a data flow graph?
What do you understand by overflow errors?
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
Is data warehousing different from data mining?
What is the architecture of abinitio?
How to move or copy the project parameter or project object to my sandbox?
How do you add default rules in transformer?
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
What happens when we provide null key to sort, merge and pbks in Abinitio ?
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)?
Why might the optimizer use a table scan when an index is available?