Total Answers Posted # 67
Total Answers Posted for My Questions # 54
Total Views for My Questions # 161966
Users Marked my Answers as Correct # 415
Users Marked my Answers as Wrong # 278
Question { 17309 }
Hi can any one tell me the difference between persistence
and dynamic caches? On which conditions we are using these
caches?
Answer
1)When you use a dynamic cache, the Informatica Server
updates the lookup cache as it passes rows to the target.
2)In Dynamic, we can update catch will New data also.
3) Dynamic cache,Not Reusable
(when we need Updated cache data, That only we need Dynamic
Cache)
Persistent:--
1)a Lookup transformation to use a non-persistent or
persistent cache. The PowerCenter Server saves or deletes
lookup cache files after a successful session based on the
Lookup Cache Persistent property.
2) Persistent, we are not able to update the catch with New
data.
3) Persistent catch is Reusable.
(When we need Previous Cache data, That only we need
Persistent Cache)
I think it will help you.
Any,,,??,,,or ,,corrections let me know,,,,,,,
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 8 Yes | 0 No |
How to create a mapping ?
id date
101 2/4/2008
101 4/4/2008
102 6/4/2008
102 4/4/2008
103 4/4/2008
104 8/4/2008
O/P - shud have only one id with the min(date)
How to create a mapping for this
Answer
First Group by ID,
Then go with min (date) in same Agg Transformation.
I think its Help you,,,,,,
Any ??? r Corrections,,,Let me know
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 21 Yes | 11 No |
from Source 100 rows are coming, on target there are 5 m
rows which options is better to match data
1. Joiner
2 No cache
3. Static
4. Dynamic
Answer
(Related to Sorce source rows),
Can u Explain (5 m rows Briefly)
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 3 Yes | 1 No |
from Source 100 rows are coming, on target there are 5 m
rows which options is better to match data
1. Joiner
2 No cache
3. Static
4. Dynamic
Answer
Master,Detail Column,Data catch,Index
catch ,Catch Size also.
(Process Begins with Condition,Comparing, Indexing)
No Catch :-With out Catch, its not easy find(5 records)
Relavtive Data.
Static ;- Catch will Keep the Target Rows to Compare with
Sourece Rows.
(Process Begin with Condition,Comparing).
Dynamic :- The Catch Data will be Update on DataFlow
also. ,,,
| Is This Answer Correct ? | 2 Yes | 4 No |
why sequence generator should not directly connected to
joiner transformation ?
Answer
dynamically.
We can not join this number against any column in other
tables...
So.. we can not connect sequence generator with joiner.
and also,
Main reason is joiner is a Active transformation.Means it
can alter the number of rows.
So, if u connect sequence generator with joiner the outcome
sequence will not be proper.
Any Queries or Corrections
'srinu.srinuvas@gmail.com'
| Is This Answer Correct ? | 27 Yes | 2 No |
What is Target Update Override? What is the Use ?
Answer
And still we need update on this target from Informatica.
We neeed to define keys at informatica level and use update
override in target property. This way we can update the
table.
Any Queries or Corrections
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 19 Yes | 4 No |
difference between source based commit? and target based
commit? which is better with respect to performance?
Answer
Both are Having the Same importence.
You can go for commit based on Importence,Requirement only.
If your source have limit then go for source based commit,
If your Target have limit then go for Target based commit.
Any ??? or Corrections,,let me know
‘Srinu.srinuvas@gmail.com ‘
| Is This Answer Correct ? | 8 Yes | 4 No |
how can we perform incremental aggregation?explain with
example?
Answer
Properties only.
Ex:-
You Target Table loaded(with Agg Caluclation) 100 Records
on yesterday ,
Now newly you have 50 Records(25 update,25 insert),
To done the Agg calculation for Updated Records ,Insert
Records you need to
Perform Incremental Aggregation.This is simple way to
increase the Performance,
Redusing the time etc.
If you not perform the Incremental Aggregation, you can
do the same thing
In another way.But it’s lenthy.
Any ??? or Corrections,,let me
know ‘Srinu.srinuvas@gmail.com ‘
| Is This Answer Correct ? | 12 Yes | 9 No |
Please explain in detail with example about
1.Confirmed Dimension.
2.Junk Dimension.
3.Degenerated Dimension.
4.Slowly changing Dimensions
Answer
The dimensions which is used more than one fact table is
called conformed dimensions.
Ex-Product Dimension related to Order fact, Sles fact,,,,.
2.Junk Dimension-
A "junk" dimension is a collection of random transactional
codes, flags and/or text attributes that are unrelated to
any particular dimension.
A good example would be a trade fact in a company that
brokers equity trades.
fact would contain several metrics (principal amount,net
amount, price per share, commission, margin amount, etc.)
and would be related to several dimensions such as account,
date, rep, office, exchange, etc.
3.Degenerated Dimension-
In a data warehouse, a degenerate dimension is a dimension
which is derived from the fact table and doesn't have its
own dimension table.
ex-line no in a Facttable,,,,
4.Slowly changing Dimensions-
A Slowly Changing Dimension (SCD)is a dimension that
changes over time.It may change immediately and it may also
change quite rapidly.
ex-nothing but Inserts,updates,,,,
Any corrections:-
Srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 29 Yes | 3 No |
Why we need XMLs?
Answer
The not relate to Informatica.
In informatica Sources like Oracle,Teradata,Db2,Sql server,
Informix in the same way XML also one of source.
We can work with XML source also.
Any Corrections letme know.
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 2 Yes | 6 No |
Question { 21075 }
LOOKUP Condition is nothing but a Join condition?
What type of join condition it,by default ?
Using the LookUP Condition How many types of relational
conditions we can make ?
Answer
Lookup Trans is a Passive,
It wil return all source rows,Match or Unmatch,,,
Source column Checks with LookupCache column , wright ?
Return port may be Value or null.
Normaljoin wil Returns all Match rows only.
May be your Answer not Correct.
If any corrections 'srinu.srinuvas@gmail.com'
| Is This Answer Correct ? | 2 Yes | 5 No |
How many mapplets u have created? and what is the logic used
Answer
What is Mapplet? What is logic?
We can create any No of Mapplets for 1 mapping.
Thaere is no limit for Mapplets.
Every mapplet can have a Logic or logics,,,,,,
There is no limit for logics.
Any corrections let me know
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 1 Yes | 4 No |
why do we go for update strategy tr in SCD rather using the
session properties?
Answer
Seession Properties like pre Souurce Rows
INSERT,UPDATE,REJECT,DELETE ,,
Using Session Properties We can do single flow only.
SCD aplicable for Insert,Update,,at a time using Update
Strategy trans only.
Using Update Trans we can creat SCD mapping easily.
Any Corrections Let me know
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 10 Yes | 4 No |
There are n numbers of flatfile of exactly same format are
placed in a folder .Can we load these flatfile's data one
by one to a single relational table by a single session??
Answer
Have you attend Recently for TCS,,,?
You need to load 10flatfiles to One relational source,,?
You can keep 10flat files in a single folder.Just assign
the folder path as a Source path in SESSION PROPERTIES.
it will make it 1 flatfile source.
By a simple Mapping,make it single Relational source.
Any corrections,,,,,srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 4 Yes | 11 No |
