How you can create cross joined output using join component ?

Question Posted / uday

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 ?

4 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

More Ab Initio Interview Questions

How you can test a dbc file ?

In Join component which record will go to unused port and which will go to reject port ?

what is the use of catlog or catlogfile?

What are the reasons for which business can trust the approach of data processing?

How you can create cross joined output using join component ?

Why might the optimizer use a table scan when an index is available?

Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?

I am having 10 records in i/p file,and i want to load only one record at a time to the output file.Then how can i do it?

Suppose you find the term validation mentioned with a set of data, what does that simply represent?

how to insert/update a csv file by comparing it with another csv file?

I had 10,000 records r there i loded today 4000 records, i need load to 4001 - 10,000 next day how is in Type 1 and how is it on type 2?

What is the difference between check point and phase?

For more Ab Initio Interview Questions Click Here