How you can create cross joined output using join component ?
Answer Posted / 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 View All Answers
How to move or copy the project parameter or project object to my sandbox?
What is a rollup component? Explain about it.
What are the fundamental blocks of co> operating system of ab initio?
What is m_dump?
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?
Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?
How can you force the optimizer to use a particular index?
Mention some ways for improving performance of a graph?
Why might you create a stored procedure with the with recompile option?
explain checkin and checkout?
Describe the grant/revoke ddl facility and how it is implemented?
What is common among data validity and data integrity?
Have you used rollup component? Describe how.
What is a partition and what are the different types of partition components in abinitio?
Explain what is the architecture of abinitio?