How to jion 2 tables, without using any condition?
Answer Posted / balu024
use union transformation, if two tables having same meta data
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What do you mean by worklet?
What do you mean incremental aggregation?
What is option by which we can run all the sessions in a batch simultaneously?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is event and what are the tasks related to it?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Can you generate sequence numbers without using the sequence generator transformation?
What you know about transaction control transformation?
How to create or import flat file definition in to the warehouse designer?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain the different dimensions.
What is decode in static cache?
Briefly define a session task?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is the maplet?