What is a mapping, session, worklet, workflow, mapplet?
No Answer is Posted For this Question
Be the First to Post Answer
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
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 u access a repository created in previous version of Informatica?
What are the different Lookup methods used in Informatica?
Difference between flat files and relational sources?
SCD2 will work on only dimension tables as well as fact Table?
what is pmrep command?
How can we use external procedural logic in informatica?
Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?
Explain the difference between etl tool and olap tools?
where is the cache (lookup, index) created and how can you see it.
How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)