In update strategy target table or flat file which gives
more performance ? why?
Answer Posted / nagaraju
flat file is better than relational becoz there is no index concet in flat file
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are mapplets?
Write the program through which the records can be updated?
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.
How are indexes created after completing the load process?
What are different types of transformations available in informatica?
What are the mapping parameters and mapping variables?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Enlist the tasks for which source qualifier transformation is used.
How can we update a record in the target table without using update strategy?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How can we use mapping variables in informatica?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What are Dimensional table?
To import the flat file definition into the designer where should the flat file be placed?