how to identify new and old values in source qualifier or
any other transformations using informatica

Answers were Sorted based on User's Feedback



how to identify new and old values in source qualifier or any other transformations using informat..

Answer / sanjay

By using the scd2..we can keep the track of the old and new
records.
There are 3 ways:
1.Version Num
2.Date
3.Flag

Is This Answer Correct ?    1 Yes 0 No

how to identify new and old values in source qualifier or any other transformations using informat..

Answer / 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

More Informatica Interview Questions

Is there any way to read the ms excel datas directly into informatica?

0 Answers  


what is unique constraint error ?

2 Answers   TCS,


What is the Rankindex in Ranktransformation?

7 Answers  


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

0 Answers  


waht is dataware house

2 Answers  






is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers   IBM,


What are the main features of Oracle 8i with context to datawarehouse?

0 Answers  


scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,


What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,


how to load only the first and last record of a flat file into the target?

8 Answers   CTS,


Mention a few design and development best practices for informatica?

0 Answers  


How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.

1 Answers   CTS,


Categories