Answer / gopal

In the Designer, select the mapping and right click in
Repository navigator, then you can get the option like
Export objects.Click on that. It will ask you to save in
which location. Then you can save the XML dumps(the object
format is XML) in any folder. Then you can import it into
production.
But generally you have to rise request and send the
dumps.You should not import with out permissions. Take care.
Another way is to open production mapping designer
work space and drag the mapping from DEvelopment. Then you
can observe copy wizard. Click on that it copies to
production.

In production server generally client side people
will do. We should not do.

Answer / ganesh

Using Depolyment group, We can migrate the mappings from
one repository to another repository.

Answer / thejaswini

Export the mapping from develoment repository then Go to
Production repository and import the same mapping . mapping
will be there in the production repository

or

You can also move the mapping by just drag the mapping from
development and drop it in Production repository i think
this is the simplest way hope this helps you.

Answer / tamil

Also, we can migrate the folder from one repository to
other using Repository Manager.

Answer / tkdhar

We can copy Workflows from development to production from
Repository Manager. We need to change the name of
integration services while migrating the code. If the
mapping is already exists in the production that then we
may need to resolve the conficts as well.

Answer / usha

Step1: we can migrated the objects by using export and
import method.
Step2:- Copy mapping from Dev and paste it in prod Folder.
Step3:Drag mapping from Dev and paste it in PROD FOLDER

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,

where to select code page option?

2 Answers   TCS,

tell me the informatica architecture

1 Answers   Banca Sella, Wipro,

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,

How to load relational source into file target?

3 Answers   IBM,

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

what are the types of facts with Examples?

3 Answers  

Describe data concatenation?

0 Answers  

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  

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

3 Answers   CTS,