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
- 6002 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What happens when a session fails and you click on recover?
How an expression transformation differs from aggregator transformation?
Explain the shared cache and re-cache?
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 .
Write the unconnected lookup syntax?
How to generate sequence numbers?
What is update strategy transform?
How can you increase the performance in joiner transformation?
What is an unconnected transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
what is the size of u r source(like file or table)?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
