Which transformation can be created only as reusable transformation but not as non-reusable transformation?
1 1151How to load the name of the current processing flat file along with the data into the target using informatica mapping?
679Name at least 5 different types of transformations used in mapping design and state the use of each.?
660Post New Informatica Questions
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What does command task mean?
generate date / time dimension in informatica
complex mapping ur project u r invlve can u explain and give real time example give me ?
How we can use union transformation?
How we can create indexes after completing the loan process?
what is the size of your data warehousing?
how we can load rejected record's at run time?(not through bad files)
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. ?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is a pre-defined event and user-defined event?
Explain sessions. Explain how batches are used to combine executions?
How does a sorter cache works?
How to create the list file having millions of flat files while indirect loading in informatica? 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?
What the difference is between a database, a data warehouse and a data mart?