How to convert flat file into xml file?
How to tune joiner?
Answer Posted / rahul
follow the below stepd to tune the joiner t/r ( which i
know)
1. select sort input and make sure that you send the sorted
data.
2. try to use normal join and master join than full and
detail join.
3.try to mark the master table which has less no.of rows
| Is This Answer Correct ? | 3 Yes | 13 No |
Post New Answer View All Answers
What is workflow? What are the components of workflow manager?
What is a snowflake schema?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Write the program through which the records can be updated?
Why sorter is an active transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are the types of schemas we have in data warehouse.
What is the use of source qualifier?
How to use pmcmd utility command?
What is the way to execute pl/sql script using informatica mapping?
What is the difference between stop and abort in informatica
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How to do unit testing in informatica? How to load data in informatica ?
How we can use union transformation?