) Diff.between Output index and Output indexes?
- 4 Answers
- 34653 Views
- TCL, TCS, I also Faced
- E-Mail Answers
Answer Posted / harika motepalli
Both Output index & output indexes used for "Conditional assignment" of your input data to out ports but the only difference is Output_index allows to assign to only 1 output port whereas Output_indexes allows to assign to multiple output ports.
********************************* Eg 1 **********************************
out::output_index(in)=
begin
out:1:if ( in.country=='Malaysia') 0 ; // if country name is Malaysia then divert input records to out0 port
out:2: if (in.country--'Singapore') 1;
out:: 2;
end;
**************************** Eg 2 **********************
out::output_indexes(in)=
begin
out:1:if ( in.country=='Malaysia') [ vector 0,1] ; // if country name is Malaysia then divert input records to out0 & out1 ports
out:2: if (in.country--'Singapore') [ vector 2 ];
out:: [vector 3 ];
end;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
Can you explain the performance and scalability of co> operating system?
What are the various types of layout supported by abinitio?
What is the difference between check point and phase?
What are the functions of the replicate and dedup component?
How can you import XML repositories exported from different tools like ODI
What are the fundamental blocks of co> operating system of ab initio?
Have you used rollup component? Describe how.
What metadata importer can do in ab initio?
How can I run the 2 gui merge files?
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
How can you force the optimizer to use a particular index?
Have you worked with packages?
What dedup-component and replicate component does?
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)?
