In the SEQ generator which property has to be set to
generate seq No. when the input data is more than the max
limit.
Answer Posted / bhaskar
Cycle
Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
Explain do we need an etl tool? When do we go for the tools in the market?
What are dimensions?
What is etl process? How many steps etl contains?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
What is Data Vault???
What is initial load and what is full load?
Can u access a repository created in previous version of Informatica?
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.
Can we create Hierarchies in generic datasources?
dimension object created in oracle can be imported in designer?how?
what are the session parameters? How do u set them?
what are the reports developed in sap bw project and what is the requirement for developing it?
SCD2 will work on only dimension tables as well as fact Table?
Explain the key challenges that you face while performing etl testing.