Answer Posted / gyana behera
mapping override means it is nothing but the pre and post
sqls in sourse qualifier tr..
Session override means it is the pre and post sql of the
session level.
hi..in any concern please send a mail..i am working in
Capgemini..please i am wating for ur unsolved questions
(gyana.informatica@gmail.com)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Where is metadata stored?
Explain pushdown optimization and types in informatica
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 do you set a varible in incremental aggregation
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is mapping debugger?
What is substr in informatica?
Briefly describe lookup transformation?
What are the components of workflow manager?
How do you migrate data from one environment to another?
What is domain and gateway node?
What is a passive transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is a pre-defined event and user-defined event?
Reusable transformation and shortcut differences