In incremental loading using Mapping variable if session
failed with any of reason in the middle of process. is the
Mapping variable remains constant or change?
- 1 Answers
- 10036 Views
- TCS, I also Faced
- E-Mail Answers
Answer / subhankar chatterjee
Mapping Variable will store its value in the repository once the Session run successfully.If the session fails the Mapping Variable will not be updated with the new value.
| Is This Answer Correct ? | 40 Yes | 1 No |
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
Scheduling properties,whats the default (sequential)
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
How are indexes created after completing the load process?
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
What is the benefit of partitioning a session?
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
Explain one complecated mapping?
Whats there in global repository
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Teradata 
