How to load the data from an excel sheet to input file in a
graph?
- 2 Answers
- 16757 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / chand
by using readxml component, you can load data into input
file.
| Is This Answer Correct ? | 6 Yes | 3 No |
)what is wrapper script?where it is going to execute and why we go for wrapper?
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 macro?At what situation we have to face?
Can someone tell me the behaviour of next_in_sequence() and innovation_number() in a multifile. Suppose I have records 1,1,1,2,2,3,4,4 in a 4ways mfs file. Data in each partition is: 0th : 1,1,1 1st : 2,2 3rd : 3 4th : 4,4 What will be the sequence of these records if I pass next_in_sequence() and innovation_number() ? Also how can I extract 3rd record from each of the 4 partitions of a 4way multifile through AbInitio? In unix we can use m_dump
What is the default layout of a component ? Is it mandatory to set the layout of a component ?
explain the environment varaibles with example?
Have you eveer encountered an error called "depth not equal"?
what is the difference between ab_work_dir and .work
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
What is the syntax for m_dump in abinitio?
Explain the methods to improve the performance of a graph?
How can you achieve scan using reformat ?
Teradata 
