in aggregator transformation we want to get middle record
how to implement, source containg empno,name sal,deptno,address
Please follow the below, that would be helpful.
https://www.bullraider.com/database/informatica/scenario/101-informatica-scenario35
Is This Answer Correct ? | 0 Yes | 0 No |
WAT IS TEXT LOAD?
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,
Without using Lookup & Sequence Generator, How to generate Sequence?
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
What are variable ports and list two situations when they can be used?
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?
What are the basic needs to join two sources in a source qualifier?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
What is DR strategy for Informatica project?