What are active transformations? Name them.
Answer / mahi
Active transformation change the rows that pass through the mapping.
aggregator,filter,sorter,router,source qualifier,transaction control ete.. are active transformations in informatica.
| Is This Answer Correct ? | 0 Yes | 0 No |
Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks
What are mapping parametres and variables in informatica?
What are the types of presistent cache in look up tr.
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
How to generate a single mapping for both the historical and incremental load.
i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?
what is semi-additive fact?where did u used?
i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override
What is the difference between IN and Exists in Oracle?
What are the data movement modes in informatcia?
Explain your project of banking domian.