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 ?
1 21914If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
3 13676How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
1 4184i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.
3 7161How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
10 25872I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
5 11204I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
1 4635Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.
2195What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
TCS,
5 20004Post New Informatica Questions
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is meant by incremental aggregation?
what is the complex transformation you used in informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is the use of an aggregator cache file?
How many ways are there to do 'remove duplicate records in informatica'?
Enlist the differences between database and data warehouse.
How identifying bottlenecks in various components of informatica and resolving them?
how many types of dimensions are available in informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
where to store informatica rejected data? How to extract the informatica rejected data?
How to call shell scripts from informatica?
How to improve the performance of a session using sorter transformation?