Interested to Buy Any Domain ? << Click Here >> for more details...
) Diff.between Output index and Output indexes?
- 4 Answers
- 37085 Views
- TCL, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / suman sv
Use output-index when we want to direct a single record to a single transform-output port.
Ex: suppose there are 100 input records and two output ports.
According to the transform function you specify for output-index, the split can be 50/50, 60/40, 0/100, 99/1, or any other combination that adds up to 100.
Use output-indexes to direct a single record to multiple transform-output ports.
Ex: out :: output_indexes(in) =
begin
out :1: if (in.kind == "a") [vector 0, 1, 2];
out :2: if (in.kind == "b") [vector 2, 3, 4];
out : : [vector 5];
end;
it directs records as:
Ports 0, 1, and 2 if the field in.kind is “a”
Ports 2, 3, and 4 if the field in.kind is “b”
Port 5 if otherwise
| Is This Answer Correct ? | 43 Yes | 1 No |
Answer / chiranjiv pandey
When we use output index, a single record can go only single
port but in case of output indexes one record can go one or
more that one port.
| Is This Answer Correct ? | 41 Yes | 0 No |
Answer / 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 |
Answer / sasi
When we use output index in reformat having multiple output
ports it decides through which port the output goes...
In case of output indexes the output goes through all the
ports..
| Is This Answer Correct ? | 12 Yes | 15 No |
What is a data processing cycle and what is its significance?
Have you used the rollup component? Describe how?
what is difference between fuse and join? Explain in detail? In which scenario we will use them?
What are the types of data processing you are familiar with?
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.
Within a cursor, how would you update fields on the row just fetched?
What is local and formal parameter?
How to create a repository in abinitio for stand-alone system(local nt)?
What is the function that transfers a string into a decimal?
What is a look-up?
Can you run air sandbox run using pset ?
What do you understand by overflow errors?
Teradata 
