|
INTERVIEW QUESTIONS
DATA WAREHOUSING
ABINITIO
DETAILS
Question: What is driving port? When do you use it?
Answer: When you set the sorted-input parameter of "JOIN" component to "In memory: Input need not be sorted", you can find the driving port. Generally driving port use to improve performance in a graph.
The driving input is the largest input. All other inputs are read into memory.
For example, suppose the largest input to be joined is on the in1 port. Specify a port number of 1 as the value of the driving parameter. The component reads all other inputs to the join — for example, in0, and in2 — into memory.
Default is 0, which specifies that the driving input is on port in0.
Join also improves performance by loading all records from all inputs except the driving input into main memory.
|
|
|
Category |
Abinitio Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 6788 users |
Added on |
7/25/2011 |
Views |
70549 |
Rate it! |
|
|
Question:
What is driving port? When do you use it?
Answer:
When you set the sorted-input parameter of "JOIN" component to "In memory: Input need not be sorted", you can find the driving port. Generally driving port use to improve performance in a graph.
The driving input is the largest input. All other inputs are read into memory.
For example, suppose the largest input to be joined is on the in1 port. Specify a port number of 1 as the value of the driving parameter. The component reads all other inputs to the join — for example, in0, and in2 — into memory.
Default is 0, which specifies that the driving input is on port in0.
Join also improves performance by loading all records from all inputs except the driving input into main memory. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
How to get DML using Utilities in UNIX?
|
View Answer
|
|
What is semi-join?
|
View Answer
|
|
How would you do performance tuning for already built graph ? Can you let me know some examples?
|
View Answer
|
|
How to do we run sequences of jobs ,, like output of A JOB is Input to B How do we co-ordinate the jobs
|
View Answer
|
|
What is the difference between .dbc and .cfg file?
|
View Answer
|
|
Sift links to MFS files on Unix for Ab Initio ? what is this .... 2) $pound what is this 3) $? what for it is used 4) types of loading 5 overwrite when it used ?
|
View Answer
|
|
How to find the number of arguments defined in graph?
|
View Answer
|
|
Difference between conventional loading and direct loading ? when it is used in real time .
|
View Answer
|
|
can anyone tell me what happens when the graph run? i.e The Co-operating System will be at the host, We are running the graph at some other place. How the Co-operating System interprets with Native OS?
|
View Answer
|
|
How to work with parameterized graphs?
|
View Answer
|
|
What are the most commonly used components in a Abinition graph?
can anybody give me a practical example of a trasformation of data, say customer data in a credit card company into meaningful output based on business rules?
|
View Answer
|
|
How to Improve Performance of graphs in Ab initio? Give some examples or tips.
|
View Answer
|
|
How to Schedule Graphs in AbInitio, like workflow Schedule in Informatica? And where we must is Unix shell scripting in AbInitio?
|
View Answer
|
|
What r the Graph parameter?
|
View Answer
|
|
Please let me know whether we have ab initio GDE version 1.14 and what is the latest GDE version and Co-op version?
|
View Answer
|
|
Explain the differences between api and utility mode?
|
View Answer
|
|
How do we handle if DML changing dynamicaly
|
View Answer
|
|
Can anyone please explain the environment variables with example?
|
View Answer
|
|
What does layout means in terms of Ab Initio
|
View Answer
|
|
What is the difference between sandbox and EME, can we perform checkin and checkout through sandbox/ Can anybody explain checkin and checkout?
|
View Answer
|