Interested to Buy Any Domain ? << Click Here >> for more details...
how to use incremental load?
- 2 Answers
- 8149 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Whenever an OLTP records update or insert in the source
,then the records are loaded in to target as a new record.
Using SCD type 2 we can acheive the incremental load.
If it wrong means chandranmca2007@gmail.com
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / moorthy g
Source --->SQ ----> Expression ---> Target
===> Create Mapping Variable
===> In SQ use sql override
where startdate < $$date
====> In expression use variable port,
setmaxvariable($$date, startdate)
=====================================
You can find variable value in Log fine and session RC you
can find it.
| Is This Answer Correct ? | 0 Yes | 1 No |
can you please explain me pre session and post session options?
how to get the data from the client machine and how to get server location data to client loction can any body explain to me
hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.
Whats the difference between informatica powercenter server, repositoryserver and repository?
Describe the impact of several join conditions and join order in a joiner transformation?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
Write the program through which the records can be updated?
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How do you manage the Parameter files while migrating your data from one environment to another environment?
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
Teradata 
