How to convert flat file into xml file?
How to tune joiner?
Answers were Sorted based on User's Feedback
Answer / sameer
i think if u want to convert flat-file source into xml then we can use xml transformation because using xml transformation we can convert flat file source as in xml using xml transformation
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
Under which circumstances, informatica server creates reject files?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
how to join the two flatfiles using the joiner t/r if there is no matching port?
what is the difference between Informatica7.1 & informatica 8.1
what is flat file override?
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
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
What is aggregate cache in aggregator transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.