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.

Define sessions in informatica etl?

1 Answers  

---

What is the difference between a repository server and a powerhouse?

1 Answers  

---

What are different types of transformations available in informatica?

1 Answers  

---

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  

---

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,

---

What the difference is between a database, a data warehouse and a data mart?

1 Answers  

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

what is shared Cache. when we will use shared Cache?

4 Answers  

---

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,

---

what is shortcut in informatica? difference between shortcut,reusable object?

2 Answers   Virtusa,

---

There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.

0 Answers  

---