Interested to Buy Any Domain ? << Click Here >> for more details...
In Join component which record will go to unused port and
which will go to reject port ?
- 3 Answers
- 26826 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kumarg
In case of inner-join all the records not matching the key
specified goes to the respective unused ports, in full
outer-join none of the records goes to the unused ports. In
case of reject port, records which do not match with DML
come to the reject port.
| Is This Answer Correct ? | 23 Yes | 2 No |
Answer / akj
In case of inner-join all the records not matching the key
specified goes to the respective unused ports, in full
outer-join none of the records goes to the unused ports.
All the records which evaluates to NULL during joiin
transformation will go into reject port if the limit +
ramp*number_of_input_records_so_far <
number_of_input_records_so_far.
| Is This Answer Correct ? | 15 Yes | 2 No |
Hi,
In join component suppose if we r using join type as
innerjoin,which records r going to meet the particula type
that records will go to the outport and remaining records
will go to the unused port.
suppose our data contains null values will go to reject
port.
| Is This Answer Correct ? | 3 Yes | 0 No |
In abinitio, what types of parallelism are used?
Difference between output_index and output_indexes in reformat
How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
Define ramp limit in ab initio?
In which scenario, .rec files will not get created even if graph fails ? How to use in abinitio graph?
. How we can remove temp files of a failed job if .rec is not available
Is data warehousing different from data mining?
i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?
How can you achieve scan using reformat ?
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?
Teradata 
