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 |
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
Quickly characterize reusable change?
What are connected or unconnected transformations?
How many ways a relational source definition can be updated and what are they?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are the mapping parameters and mapping variables?
What are the static cache and dynamic cache in informatica?
How can you run a session without using server manager?
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?
SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve