How you can create cross joined output using join component ?

Answers were Sorted based on User's Feedback



How you can create cross joined output using join component ?..

Answer / chamanvir kaur

Set the key as NULL - {}

Is This Answer Correct ?    5 Yes 0 No

How you can create cross joined output using join component ?..

Answer / sai

Keep Key is Null you can get cross join

Is This Answer Correct ?    2 Yes 0 No

How you can create cross joined output using join component ?..

Answer / nandini

you can use join component with parameter join type “inner join” as cross join is reduced form of inner join given where clause.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Ab Initio Interview Questions

What will be the output of using partition by Round-Robin after the partiton by key in ab initio?

1 Answers  


what is the difference between the .dbc and .cfg extensions and give any clear information ?

4 Answers   Cognizant,


Why creation of temporary files depends on the value of MAX CORE ? How to use in abinitio graph? 10. What is the diff between abinitiorc and .abinitiorc files ? How to use in abinitio graph? 11. What is the use of allocate()? How to use in abinitio graph? 12. What is use of branch in EME ? 13. How you can break a lock in EME ? How can you lock a file so that only no one other than EME admin can break it ? How to use in abinitio graph? 14. When you should be using ablocal() ? How you can use ablocal_expr? How to use in abinitio graph? 15. Why you should not keep the layout as 'default' for input table component ? How to use in abinitio graph? 16. What is dynamic lookup ? How to use in abinitio graph? 17. What is dependent parameter ? How to use in abinitio graph? 18. What is BRE ? (Business Rule Environment - This is a recent addition in abinitio package) How to use in abinitio graph? 19.What is output index ? How to use in abinitio graph? 20. How you can track the records those are not getting selected from ‘select’ in reformat component ? How to use in abinitio graph? 21. Can we have more than one launcher process for a particular graph ? How about agent ? How to use in abinitio graph? 22. There are lot of new fuctions added in 2.15 , you can ask about them ? How to use in abinitio graph? 23. How can you run multiple instances of a graph in parallel? How to use

0 Answers   Wipro,


Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?

0 Answers  


Need Ab-Initio Material - Harini

7 Answers  


Which Ab initio version has Hadoop connector ? and what is the latest GDE version available ?

1 Answers   Infosys, TCS,


wt is meant by repartioning in howmany ways it can be done.

2 Answers  


Have you worked with packages?

0 Answers  


I have $AI-SERIAL/DML------> (SERIAL FILE LOCATION) AND $BDS-SERIAL/DML---------->(what is the location what is mean)?

1 Answers  


When we should use 'jobid' for commit table (Output table component??

1 Answers   HCL,


How do you improve the performance of a graph?

0 Answers  


What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?

0 Answers  


Categories