In Flat file
Input is
A
B
C
I need output like this
A
A
A
B
B
B
C
C
C. How will u achieve this?
Answer Posted / abhinaw prakash
We can use normalizer for this.
send the ports from SQ to Normalizer.
In Normalizer put the occurrence of the incoming column as 3.
Connect the only column from SQ to the 3 incoming port in
Normalizer.
Connect the O/P column from Normalizer to target.
Is This Answer Correct ? | 20 Yes | 0 No |
Post New Answer View All Answers
Explain the scenario which compels informatica server to reject files?
What are the types of caches in lookup?
What is a sorter transformation?
What is the need of etl tools?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How many ways a relational source definition can be updated and what are they?
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 is meant by query override?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How to differentiate between the active and passive transformations?
what is index?how it can work in informatica
What is enterprise data warehousing?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain your project of banking domian.
Can you use flat files in Mapplets.