Interested to Buy Any Domain ? << Click Here >> for more details...
How to convert flat file into xml file?
How to tune joiner?
- 2 Answers
- 11160 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 |
How to load only the first and last record of a flat file into the target?
Explain the types of transformations?
What is the difference between a shortcut of an object and copy of an object? Compare them.
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
what is mapping optimization? wat are the techniques for tat
What is the difference between view and materialised view?
How do you join more than 3 flat files in informatica?
wat are deployement groups in informatica, how it will be used for developers
How do you load only null records into target? Explain through mapping flow.
What are the issues you have faced in your project? How did you overcome those issues?
Teradata 
