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 21370If 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 12990How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
1 3808i 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 6383How 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 24074I 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 10074I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
1 4218Could 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.
1967What 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 19034Post New Informatica Questions
Target increases every day even though no new record was inserted
What is native users?
Why union transformation is an active transformation?
What is workflow manager?
How to load a Dimension ? and how to load a fact table?
What is dimensional table? Explain the different dimensions.
How you prepared reports for OLAP?
How you know when to use a static cache and dynamic cache in lookup transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is pmcmd command?
How many input parameters can exist in an unconnected lookup?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
what are the deliverables?in your project?
