| Other Informatica Interview Questions |
|| Asked @
|Hi all, i am new to this site and new to Informatica too. I
have few questions regarding that.
1) When we load flat files into target tables how do we
identify duplicates? and where do load the duplicate
records for further reference?
2) How do we do chage data capture? Is this Slowly changing
Thanks in Advance
|SRC1 -> EXP -> AGGR ->
SRC2 -> EXP ->
Above is a maaping with two pipeline connected to the taret
TGT. Design wise is this design is correct or not ?
|where does the default group roew in a router is stored
what is the default size of memory in router
I've 110 records in my table but 101 records contains an
error. When I run the session, I want to load the 100
records into the target. Can anyone suggest me the best
solution for this...
Thanks in Advance,
|from Source 100 rows are coming, on target there are 5 m
rows which options is better to match data
2 No cache
|How could we generate the sequence of key values without
using sequence generator transformation in the target ??
|what is polling?
|In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal.
Is there any othere transformation than the aggrator? if
|You have defined the following:
- Commit Type = 'Target'
- Commit Interval = 10000
- writer buffer block can hold multiple 7,500 rows
- you are loading 40,000 records into the target
After how many records will the Informatica Server issue
a)7500, 15000, 22500, 30000, 40000
b)15000, 22500, 30000, 37500, 40000
c)15000, 22500, 30000, 40000
d)15000, 30000, 40000
|In joiner, how to load Master table in Target?
|In EMP table, for those emp whose Hiredate is same, update
their sal by "sal+500" or else for others keep the sal as it
is, how to do it by SQL query
|What is the procedure to load the fact table.Give in
|For more Informatica Interview Questions Click Here |