In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation.
If millions of files are there, how can we enter the flat file names in list file?
Post New Answer View All Answers
whats the logic to load the lower level of granularity of data to fact table.
permutations of mapplet
difference between repository database and repository service?
What is joiner change?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
how to load dimension table and fact table. plz tell me the steps.
What is the use of transformation?
Differences between version 7.x and 8.x.
What is native users?
What is event and what are the tasks related to it?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How are the sources and targets definitions imported in informatica designer?
Differentiate between router and filter transformation?
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
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.