1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

hi all
my source looking like below
column1 column2
101,102,103 abc,def,ghi
1001,1002,1003 a,b,c


i want my target is

column1 column1
101 abc
102 def
103 ghi
1001 a
1002 b
1003 c


any one can you help

Question Posted / fiero

Answer Posted / fiero

Is the number of values in each column going to be a constant (i.e. 3 in this case)? If yes, there are couple of ways to do it.

Option 1:
Pass column 1 and 2 to an expression transformation.
Use string functions to determine the positions of commas in column 1 and store the values in individual output fields (e.g. 101 in field 1, 102 in field 2, etc). Do the same with the column 2 values.
Pass the individual o/p fields to a normalizer to transform the columns into rows.

Option 2:
Since the values are separated by comma, you can choose to write column 1 to a flat file target. Do the same with the column 2 values.
Then, use the files created from step 1 as CSV (delimited) file sources and use normalizer to transform them into rows.

Note: Normalizer will work only if the number of columns is known. If the number of columns can vary during run time, then you will have to think of something else.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the aggregator transformation?

630

Performance tuning in UNIX for informatica mappings?

2145

what is the difference between informatica6.1 and infomatica7.1

1719

Explain where to store informatica rejected data? How to extract the informatica rejected data?

582

Explain pmcmd command usage in informatica

708




what is the -ve test case in your project.

1854

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1644

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1636

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1610

What is different between the data warehouse and data mart?

630

Explain the mapping variable usage example in informatica

635

Tell me about MD5 functions in informatica

528

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

636

What if the source is a flat-file?

594

Enlist the advantages of informatica.

632