Answer / tanmaya

Hi All,


The basic concept of versioning in any tool/technology
is "To track the changes with versions"


For Example,


A text file with TEST is there with 123 as data. Saved as
Test.

Next day, changes are done for TEST and now data is 456.
Save as Test. Override the previous test.


Now if we observe we will have only one file with latest
data 456. So you can't track how many times it gone through
changes and what changes are done. So to avoid these issues.


Save the TEST with 123 data as Testv0.1

Again after changes are done, Save the TEST wtih 456 as
Testv0.2


So we will have both files with old and new data and also
we can track the changes happened.


The similar concept in any versioning tool and also the
same in our Informatica also.


If we checkin the any
mapping/mapplet/workflow/session/other into server. And
those will become in read only mode.

You can't edit checked in objects.


If we wan't to edit those objects, first we need to
checkout the object that we want to modify then it will
become editable/writable mode and after
changes/modifications are done, save again checkin the
object.


So it will create multiple versions of the same object
tracking the changes that happened from the time it has
been created.


It is good practice to enter comments for every checkin and
checkout, so you can easily find out what you have done in
that particular version.

Answer / kishor baindoor

once the application is biilt we cant make the changes to
mapping directly. So we need to check out the mapping or
session or source table or target table before making
changes. Then test the load. If it is working fine then
check in. If the load is not working properly we can do
undo check out which takes it to previous stage.

Answer / himanshu arora

In simple language if you are exporting any Mapping/Session/Workflow in informatica then you have to ensure that all object should be checked in and when you are importing the same then you should take care of objects to checked out.

My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,

---

Performance tuning( what you did in performance tuning)

0 Answers   Infosys,

---

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

---

how to improve performence by using sorted input in aggrigator t/r.

2 Answers  

---

split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

1 Answers   Cap Gemini, TCS, Wipro,

---

---

1 lac of flat fles in source how to load target at a time?

4 Answers   Cap Gemini,

---

What are Target Options on the Servers?

1 Answers  

---

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

---

In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 Answers  

---

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,

---

what is the difference between copy object import objects using repositery manager which one is best

1 Answers   TCS,

---

Why do you use Mapping Parameter and mapping variable?

0 Answers  

---