Answer Posted / sudhar
Use the Dual Table as dummy table and use the Normalizer to
generate required number of rows then apply what ever logic
required to populate the Target.
For example you can create a calendar for the entire year
with the one record from the dual table using the normalizer.
But with out any source the mapping cannot be created and u
need some dummy source like the above to populate the Target.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is target designer and target load order?
Can u generate reports in Informatica?
What is workflow manager?
What is persistent lookup cache?
What is the difference between source qualifier transformations source filter to filter transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Explain lookup transformation source types in informatica
What do think which one is the better joiner or look up?
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?
How many ways are there to do 'remove duplicate records in informatica'?
Write the program through which the records can be updated?
What are the reusable transformations?
which one is better performance wise joiner or look up
lookup transformation with screenshots
Slowly changing dimensions, types and where will you use them