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 |
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
Target is zero file and how can you send the email?
What are variable ports and list two situations when they can be used?
What is the main difference between a Joiner Transformation and Union Transformation?
Explain dynamic target flat file name generation in informatica
How to Create a folder using pmrep command?
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
expain about the tune parameters?
what is row level and column level indicator?
What is mapplet in informatica?
What is a grid in Informatica?
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep