Interested to Buy Any Domain ? << Click Here >> for more details...
How to convert flat file into xml file?
How to tune joiner?
- 2 Answers
- 11183 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
Write the unconnected lookup syntax?
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is a filter transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
why we r using presql&postsql in source qualifier?
Can we update the data in flat file using update strategy?
What is the difference between warehouse key and surrogate key?
i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?
When the informatica server marks that a batch is failed?
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
Teradata 
