you 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.
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.
A mapping contains
source table S_Time(stat_year,end_year)
target table TIM_DIM(date,day,month,year,quarter)
stored procedure transformation: A procedure has two
parameters I_end_year and output parameter as O_date ,day ,
month, year, quarter, If this session is running, how many
rows will be available in the target and why?
how can i text accracy of ETL migration? i am very new to
data warehousing. we are writing ETL scripts using
SCRIPELLA tool. how can i test the correctness of data.
and we are generating reports using pentaho . is there any
easy way to test the pentaho. how can test these ETL
scripts written in scriptella?
thanks in advance
236
what is the difference between cardinality and Nullability?
99
what are business components in Informatica?
189
can be used COM component in Informatica ?
144
what are the production issues in datastage?
8
when u connect the repository for the first time it asks you
for user name & password of repository and database both.But
subsequent times it asks only repository password. why?
145
what is data modeling?
85
what is the difference steps for data modeling?
91
how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
109
what is pmrep command?
300
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?
62
what is the main role of FI on business
142
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?
101
how would u estimate the size of Aggregator transform data
and index cache?
119
Two default user groups created in the repository
are____and_____.
242
how would u estimate the size of Lookup transform data and
index cache?
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?
126
what is data modeling?
107
what are Lookup caches options? Including persistent caches.
Site Map
