In Join component which record will go to unused port and
which will go to reject port ?
- 3 Answers
- 25190 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 |
What are the functions of the replicate and dedup component?
Explain the ab initio etl tool in high level?
Mention what is rollup component?
Difference between private project parameters ,public project parameters and common project parameters?
How can you increase the number of ports of your output flow? What is the limit? Can i have 20 out ports?
how does deadlock occur?
Hi friends if u don't mind i want one question What abt READ MULTIFILE COMPONENT? PLZ GIVE BRIEFLY?
name the air commands in ab initio?
Describe in detail about lookup?
I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?
How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?
) How can you count the total no .of records in the specified partition in the Multifile?
Teradata 
