what is difference between fuse and join?
Explain in detail? In which scenario we will use them?



what is difference between fuse and join? Explain in detail? In which scenario we will use them?..

Answer / suri

Fuse: It is a component it will append the data horizontally like if we have two files from first file first record will join horizontally second file first records like all records join horizontally
Join: In join based on common key value and join type file records will be joined

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Ab Initio Interview Questions

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)?

0 Answers  


What does edp stand for?

0 Answers  


What is data mapping and data modelling?

0 Answers  


One file contains header,body,trailer records and header in a single row as well as trailer too.How to segregate these header,trailer and body records and once it gets segregated,i want to make the body data in reverse i.e if i have 10 body records,the 10th record should be the first record,9th record should be the second line,etc..

4 Answers   TCS,


What is rollup component?

0 Answers  






What are the factors on which storage of data depends?

0 Answers  


List out the file extensions used in abinitio?

0 Answers  


Explain data flow graph with an example?

0 Answers  


What is the diff between abinitiorc and .abinitiorc files ?

1 Answers   TCL,


How do you add default rules in transformer?

0 Answers  


What is difference between force_error & force_abort? How to use in abinitio graph?

2 Answers   IBM, TCL,


What do you know about partition and also tell us about partition components in abinitio?

0 Answers  


Categories