How can you join two tables without any common column present in them?
Answer / lisa
I can add one dummy column to both the tables with value '1' and join both the tables on the basis of that dummy column. But how to do the join when there are huge number of columns/huge data volume in the tables? Please reply!
Is This Answer Correct ? | 0 Yes | 0 No |
how to use incremental load?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How mapping parameter and variable works
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
How to create a non-reusable instance of reusable transformations?
What does role playing dimension mean?
How to find from a source which has 10,000 records, find the average between 500th to 600th record?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How can i send first half of the records to one target and Remaining to other target?