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 |
I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out
why normalizer transformation can not used in mapplet? plzzzz answer
Different types of Power center errors?
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
can we use bulk loading when we use look in mapping
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
In session log thier should not be a single error how will u do
What aer the out put files that the informatica server creates during the session running?
Explain what are the different types of transformation available in informatica.
which one is better either active or passive transformation in informatica
Explain about Recovering sessions?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?