Interested to Buy Any Domain ? << Click Here >> for more details...
when should one create lookup transformation ?
- 2 Answers
- 5569 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kaki
Look up transformation is used for looking up a value from
OLAP table within a mapping before populating it. For
example, I have empid and I want to get emp name to use in
the next transformation, I would search for it in a look up
table which has the emp name by giving input as emp id.
| Is This Answer Correct ? | 1 Yes | 0 No |
how do u automate Extraction process?
working of line item dimension......pls,tell overall flow
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
can be used COM component in Informatica ?
What is tracing level and what are the types?
Explain the key challenges that you face while performing etl testing.
What is grain of fact?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
how do u implement unconn.stored proc. in a mapping?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Teradata 
