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 / ganesh yadav

using Normalizer Transformation we can convert the multiple
columns as multiple rows, multiple rows as multiple columns...
rows: 1 1 1 2 2 2
a b c a b c
answer
column wise
1 a b c
2 a b c

Is This Answer Correct ?    3 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1850


What is a predefined event?

868


What is data transformation manager process?

843


What is option by which we can run all the sessions in a batch simultaneously?

897


How to configure mapping in informatica?

928


Explain the types of transformations?

817


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3820


What is olap (on-line analytical processing?

852


What are the components of Informatica? And what is the purpose of each?

842


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7952


can we override a native sql query within informatica? How do we do it?

873


What is the sql query overwrite in source qualifier in informatica

855


What are the features of complex mapping?

897


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1491


What is data caches/ index caches?

832