i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c
i want output as 1 a,b,c and 2 a,b,c ...
how can achieve this
Answer Posted / swetha
Thru Normalizer t/r we can acheieve this.
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
Can we create a node as a gateway node and the same node can be assigned to a grid?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What are the new features of Power Center 5.0?
How do we call shell scripts from informatica?
What is a filter transformation?
What is incremental aggregation?
explain about unit testing? in real time?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What are the data movement modes in informatica?
Repository user profiles
Describe data concatenation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What are connected or unconnected transformations?