i have two flat files.. containing same type of data
i want to load it to dwh..how many source qualifires i need
Answer Posted / raman m
If the 2 flat files have the same structure,then we can go
for filelist concept in informatica.
only one source qualifier is needed and the source should
be either of the flat files.
| Is This Answer Correct ? | 32 Yes | 0 No |
Post New Answer View All Answers
How do you manage the Parameter files while migrating your data from one environment to another environment?
How does a rank transform differ from aggregator transform functions max and min?
Sequence generator, when you move from develoment to production how will you reset
What are the differences between joiner transformation and source qualifier transformation?
Mention a few design and development best practices for informatica?
Please let me know how to make Data masking in informatica..
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What do think which one is the better joiner or look up?
What is confirmed fact in dataware housing?
What is different between the data warehouse and data mart?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
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 pushdown optimization $pushdownconfig parameter - informatica
What are the differences between source qualifier and joiner transformation?
Explain the difference between mapping parameter and mapping variable?