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.

How do you load only null records into target? Explain through mapping flow.

0 Answers  

---

why normalizer transformation can not used in mapplet? plzzzz answer

2 Answers   Syntel,

---

Separate from an archive server and a powerhouse?

0 Answers  

---

Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  

---

Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,

---

what is row level and column level indicator?

1 Answers   TCS,

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,

---

What are variable ports and list two situations when they can be used?

1 Answers  

---

How will you check the bottle necks in informatica? From where do you start checking?

3 Answers   HCL,

---

How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  

---

WHat all joins are there in Source Qualifier?

1 Answers  

---

which one is better either active or passive transformation in informatica

1 Answers  

---