Interested to Buy Any Domain ? << Click Here >> for more details...
how to identify new and old values in source qualifier or
any other transformations using informatica
- 2 Answers
- 5883 Views
- I also Faced
- E-Mail Answers
Answer Posted / srikanthlavu
old values you might store in target right?then use that
old values for comparision of new values by using lookup
tranformaton....give key port lkp t/n from sq and give
condition like oldvalue=newvalue
if condition true means those are old vakues
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can you generate reports in informatica?
Explain sql transformation in script mode examples in informatica
Why union transformation is an active transformation?
How do you load only null records into target? Explain through mapping flow.
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 .
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Write the program through which the records can be updated?
What do mean by local and global repository?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the limitations of joiner transformation?
How to convert multiple rows to single row (multiple columns) in informatica
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Where are the source flat files kept before running the session?
What is a repository manager?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
