Interested to Buy Any Domain ? << Click Here >> for more details...
what are variable ports and list two situations when they
can be used?
- 4 Answers
- 15849 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / bsgsr
a variable port is one which is executed after the input
port or before the output port.
the order of xecution of the ports
input, variable , output
while doing incremental loading v use variable port
while while doing any count with the source tables
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a lookup table in etl?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
where are the log files generally stored.Can you change the path of the file.what can the path be?
Explain different types of partitioning?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
how do use session mapping parameters ?(in which transformation)
What is tracing level? How many types of transformations supported by sorted input?
what do u do when DB time takes more?in sap bi
what happens if the info.server doesn't find the session parameter in the parameter file?
Compare etl & elt?
Explain about round-robi?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
Explain what is etl process? How many steps etl contains explain with example?
when will use SQL override in a lookup transformation?
tell me few points when u become TL
