How to convert flat file into xml file?
How to tune joiner?

Answers were Sorted based on User's Feedback



How to convert flat file into xml file? How to tune joiner?..

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

How to convert flat file into xml file? How to tune joiner?..

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

Post New Answer

More Informatica Interview Questions

What is aggregator transformation in informatica?

0 Answers  


From where we can start or use pmcmd?

3 Answers  


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

0 Answers   Informatica,


Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 Answers  


what is data driven in update strategy transformation?

2 Answers   HCL, PayPal,






Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  


we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,


Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,


What is a code page in Informatica

3 Answers   American Express, Cognizant, Deloitte,


we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,


What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,


scenario

1 Answers  


Categories