Interested to Buy Any Domain ? << Click Here >> for more details...
how to use incremental load?
- 2 Answers
- 8062 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 |
What are the types of maping in Getting Started Wizard?
Explain the scenario which compels informatica server to reject files?
What is critical mapping?
Can we create multiple integration service on single repository?
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 meant by LDAP users?
In update strategy target table or flat file which gives more performance ? why?
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is the difference b/w natural key and surrogate key
I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com
explain abt union t/r?
Teradata 
