what are variable ports and list two situations when they
can be used?
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 meant by incremental load?
What are the ETL Testing Operations?
Explain about the data integration suite features?
Explain and compare etl & manual development?
What are your responsibilities as an etl tester?
What is cube grouping?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
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.
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
what are the reports developed in sap bw project and what is the requirement for developing it?
how do u handle performance issues in Informatica . where can u monitor the performance ?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
what is session partitioning?
Is hadoop a etl tool?
Do we need an etl tool?