Interested to Buy Any Domain ? << Click Here >> for more details...
How do you create single lookup transformation using
multiple tables?
- 6 Answers
- 44248 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / murali vishnuvajhala
you cannot join two tables in a lookup. Lookup works only
on one underlying table.
| Is This Answer Correct ? | 4 Yes | 34 No |
Post New Answer View All Answers
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
what is the -ve test case in your project.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is olap (on-line analytical processing?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is rank transform?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is workflow? What are the components of workflow manager?
What are the types of presistent cache in look up tr.
What are the performance considerations when working with aggregator transformation?
Write the unconnected lookup syntax?
How many numbers of sessions can one group in batches?
how tokens will generate?
