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
- 6001 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
What is mapplet in informatica?
lookup transformation with screenshots
where to store informatica rejected data?
how we can load rejected record's at run time?(not through bad files)
what is Active lock explain
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is union transformation in informatica?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Mention few advantages of router transformation over filter transformation.
what is the size of u r source(like file or table)?
what is informatica metadata?
What are the new features of Power Center 5.0?
What is data transformation manager process?
What are the different lookup cache(s)?
Explain sessions and how many types of sessions are there?
