How can you recognise whether or not the newly added rows in
the source r gets insert in the target ?
- 2 Answers
- 8197 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha
In the Type2 maping we have three options to recognise the
newly added rows
Version number
Flagvalue
Effective date Range
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / atiric software(raja)
by flag value we can identify the newly inserted rows
| Is This Answer Correct ? | 1 Yes | 0 No |
How the dimensions will be loaded?
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
What are the circumstances that infromatica server results an unreciverable session?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Do you have to change the reject file b4 using reject loader utility.
What are the designer tools for creating transformations?
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.
how we can do session partition in informatica any one explain me clearly? thanks advance.
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
What is source qualifier?
Teradata 
