how do u set partition points in the mapping?
No Answer is Posted For this Question
Be the First to Post Answer
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.
what is meant by drill through?(Mascot)
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What are three tier systems in etl?
Explain what are the various etl tools in the market?
What is etl process? How many steps etl contains?
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
what are the different forms of normalization?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?
What is a mapping?
what types of repositories we can create in informatica? in real time in which type of repository we will work on?