In Join component which record will go to unused port and
which will go to reject port ?
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 |
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?
What is the difference between reformat and redefine format?
Can you run air sandbox run using pset ?
What are the operations that support avoiding duplicate record?
What is the language used in Ab Initio ?
Within a cursor, how would you update fields on the row just fetched?
Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?
What is the architecture of abinitio?
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)?
Explain batch processing in ab initio?
Hi friends, I have 100 records in my input file, if i run first,the first 10 records are stored into the output and if i run second time next 10 records stored into the output file like that please let me know the answer Thanks, krishna
what is macro?At what situation we have to face?