Interested to Buy Any Domain ? << Click Here >> for more details...
How do you create single lookup transformation using
multiple tables?
- 6 Answers
- 44299 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / koti
Re: How do you create single lookup transformation using
multiple tables?
Answer
# 1 Lookup transformation: Based upon one/more keys the
data is
retreived from one/more tables.
create a single lookup transformation by Joining the
multiple tables, having connected the keys defined in
lookup tranformation.
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
What is standalone command task?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain the aggregator transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How to create or import flat file definition in to the warehouse designer?
Can we create two repositories on same database instance in oracle?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How are the sources and targets definitions imported in informatica designer?
explain abt ur project architecture?
can you please explain me pre session and post session options?
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.
Explain the different dimensions.
What is a stored procedure transformation?
How can you generate reports in informatica?
