Interested to Buy Any Domain ? << Click Here >> for more details...
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.
2057list and discuss two approaches for updation of target table in Informatica and how they are different.
2117you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
3 6357where are the log files generally stored.Can you change the path of the file.what can the path be?
2444what 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?
1 4233
What is the difference between Data Warehousing and Data Mining?
Is hadoop a etl tool?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
where is the cache (lookup, index) created and how can you see it.
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.
In Which Transformation We Can Use Having Clause In Informatica?
What is virtual Data Warehousing?
what is the difference steps for data modeling?
if i have a query as flat file how can we load data to target table
what make u disappointmnets in u r career
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.
how do u handle performance issues in Informatica . where can u monitor the performance ?
What are the key benefits of ETL Testing?
how do u set partition points in the mapping?
