1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What are the issues that you have faced while moving your
project from the Test Environment to the Production
Environment? Please explain in depth

thanks in advance

Question Posted / shish

Answers were Sorted based on User's Feedback



What are the issues that you have faced while moving your project from the Test Environment to the..

Answer / gm

Hi,
1.sequence number problem
2.Parameter file path
3.Persistence value, Etc...

Is This Answer Correct ?    4 Yes 0 No

What are the issues that you have faced while moving your project from the Test Environment to the..

Answer / prabhu

You will mostly get the below issues

1)You need to change the current value in sequence
generator.
2)When you use union transformation export and import may
not work at times
3)when u have used absolute path for source,tgt and
parameter file names it might be a problem.
4)Unix files exported might contain control m characters

Prabhu
www.iskilltech.com

Is This Answer Correct ?    1 Yes 0 No

What are the issues that you have faced while moving your project from the Test Environment to the..

Answer / ranjan

One example can be:

1)missing link between one transformation to the next transformation.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Informatica Interview Questions

how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.

1 Answers  

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,

which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers   IBM,

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers   Mphasis,




Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

0 Answers   SeeInfoBiz, TCS,

How do you implement configuration management in Informatica?

1 Answers  

what is unit testing?tell me proceedure

0 Answers   L&T, UST,

list out all the transformations which use cache?

0 Answers   Informatica,

What is flashback table ? Advance thanks

0 Answers   Puma,

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

0 Answers  

For more Informatica Interview Questions Click Here
Categories