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
- 26991 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 |
After completion of graph what is the next process to perform? who will perform the later process?
Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999
what is the difference between i)public ii)private iii)common and client projects?
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 many types of project we can create in Abinitio? I mean public,private.......etc?
can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................
Explain the methods to improve the performance of a graph?
Mention what information does a .dbc file extension provides to connect to the database?
How will you check the latest versions in EME?
What will be the skew for, input file->partition by key-> partition by round robin->output file
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
What is the diff between abinitiorc and .abinitiorc files ?
Teradata 
