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
- 5933 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 is olap (on-line analytical processing?
What is union transformation?
What is the procedure for creating independent data marts from informatica 7.1?
Can anyone tell me the new features in Informatica 9 Version?
Explain how many types of dimensions are available in informatica?
What is informatica etl tool?
Name the different lookup cache(s)?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Slowly changing dimensions, types and where will you use them
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Can we get 1st record through Informatica(without sequence number).
What is a shortcut and copy in Informatica and how two are different with each other?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How does a sorter cache works?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
