If you want to create indexes after the load process which
transformation you choose?
Answers were Sorted based on User's Feedback
Answer / bsgsr
stored procedure transformation can be used to create and
drop indexes before and after loading into the target.
| Is This Answer Correct ? | 16 Yes | 1 No |
Answer / kalyan
use the post session SQL to craete indexes on the target
table..
| Is This Answer Correct ? | 11 Yes | 1 No |
with out using update strategy transnsformation how to update the data in mapping level
What is the difference between normal and bulk loading? Which one is recommended?
What is a taget load order?
How to retrieve last two days updated records?
What are the popular informatica products?
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is Performance tuning in Informatica?
What are the challenges you have faced in your project?
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai