Interested to Buy Any Domain ? << Click Here >> for more details...
If you want to create indexes after the load process which
transformation you choose?
- 3 Answers
- 21361 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the modules in Power Center
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Explain the difference between a data warehouse and a data mart?
Where are the source flat files kept before running the session?
In warehouses how many schemas are there?
Do you find any difficulty while working with flat files as source and target?
Name the different lookup cache(s)?
How can we use batches?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What are multi-group transformations?
How to generate sequence numbers without using the sequence generator transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is the difference between writing a joiner query in ANSI style and THETA style?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
