Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / soujanya
used to perform dml operations such as insert update delete
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
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 DR strategy for Informatica project?
can you please explain me pre session and post session options?
What do think which one is the better joiner or look up?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Explain the types of transformations?
Define Pmrep command?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Differentiate between a repository server and a powerhouse?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Write the program through which the records can be updated?
What are the main features of Oracle 8i with context to datawarehouse?
What is the benefit of session partitioning?
can anyone explain me about retail domain project in informatica?
Explain constraint based loading in informatica
