how to identify new and old values in source qualifier or
any other transformations using informatica
- 2 Answers
- 5451 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
how to duplicates from expression transformation without using sorter before that
What happens if we dont select data driven option?
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
What are the Differences between connected and unconnected lookup?
How to delete first 3 rows & last 3 rows in target table in informatica
Why we use partitioning the session in informatica?
How do you load alternate records into different tables through mapping flow?
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
what is a junk dimension ?
14 Answers Atos Origin, Cognizant, HS, NIIT, TCS,
Explain sessions. Explain how batches are used to combine executions?
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
Teradata 
